Question Re: Procedure Execution Debugging in Technology Q&A

Procedure Execution Debugging

JimDiaz — Tue, 09 May 2023 12:19:47 GMT

SQL Anywhere 17.0.10.6160

I'm interested in recording the execution of procedures and functions while debugging. If possible I would also like to record the parameter values sent to the procedure or function. Is there an automated method for doing this?

Thanks Jim

Re: Procedure Execution Debugging

chris_keating — Wed, 10 May 2023 10:04:37 GMT

Not in the debugger but perhaps the request logging level procedures+hostvars could be used for this? See RequestLogging/RequestLogFile set using sa_server_option (or via the -zr/-zo command line settings). The request log can be analyzed using sa_get_request_times which creates the temporary tables SATMP_request_time and SATMP_request_hostvar.

Re: Procedure Execution Debugging

VolkerBarth — Wed, 10 May 2023 11:14:56 GMT

I'm interested in recording the execution of procedures and functions while debugging.

What exactly do you want to get recorded (besides the parameter values, as stated in the second question)?

FWIW, you can use MESSAGE statements with the DEBUG ONLY clause and then decide via the debug_messages option whether those MESSAGE statements are executed or not. (Note, it apparently is independent of running the SQL Debugger or not.) And you might use the buitin sa_strack_trace() or STACK_TRACE() to get information about caller hierarchies and/or parameter values. – Obviously, this requires modifications to procedures and functions beforehand.

Re: Procedure Execution Debugging

JimDiaz — Thu, 01 Jun 2023 17:12:42 GMT

Thanks. I was hoping to use the sa_stack_trace or STACK_TRACE to return Owner.ProcedureName as well as the passed in parameter values. The plan was to call an internal debug procedure with the returned value(s) which would store in a table with whatever else was needed. In this way the same line of code could be added to each procedure to store the debug information.