Page 1 of 1

Is Debugging stored procedures at runtime possible?

Posted: Mon 24 Feb 2020 18:33
by samcov
I can debug stored procedures just fine, however, they have no context in the application I'm testing against.

Is there a way to debug while the program is running, only hitting break points when the code is actually invoked by the program?

Re: Is Debugging stored procedures at runtime possible?

Posted: Tue 25 Feb 2020 15:11
by alexa
Could you please describe this in more detail?

Please also see the Debugging Stored Routine section in the Help documentation.

Re: Is Debugging stored procedures at runtime possible?

Posted: Tue 25 Feb 2020 19:49
by samcov
Yes, it's very simple and happens when debugging code in most IDE's like Visual Studio.

You actually debug a running app when it runs under normal conditions, and hit break points when the user does something real.

In this case I can debug a stored procedure, but not under any real case. In my app, the stored procedures gather information about the user's login credentials that are dynamically set, so I want to see what happens in the real world, not in a simple test situation so I can see what's really going on.

Re: Is Debugging stored procedures at runtime possible?

Posted: Wed 26 Feb 2020 12:10
by alexa
Thank you for the reply.

We put this functionality to our roadmap for the next product versions.