Debugging SQLScript Procedures with Input Parameters
Back in December, I introduced the new SQLScript debugger in SAP HANA 1.0 SPS5. In that blog, I mentioned the limitation about not having the ability to debug procedures with input parameters. Today, I’m glad to announce that as of SAP HANA 1.0 SPS6(Rev 60), there is no longer this limitation. Now we have the ability to define the values of the input parameters directly in the debug configuration. Below is the new debug configuration screen. You will notice that you can specify the name of the procedure to debug.
When you click the “Input Parameters” tab, you can see all input parameters associated with that procedure. In this case, there are two, IM_VAL1 and IM_VAL2. Here I can set the values for each input parameter.
Once the debug session is initiated, you can see the input parameter values in the “Variables” tab. You can now debug as normal. I think you would agree that this is a bit nicer than having to create a wrapper procedure and hard code the parameter values in order to debug your procedures.
Check out the video demonstration on the SAP HANA Academy.