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.