Debugging a stored procedure

D

DevNick

This really doesnt have anything to do with VB, did you post in the SQL, or
to the oracle or DB people for the product you use?
Its different for each of them.

you need to be a dba to do it(security wise).
 
G

Guest

Hi,

Sorry, I should've been more clear.

I would like to debug a stored procedure from the vb.net development
environment. I am executing 'ExecuteNonQuery' (which in turn executes a
stored procedure) from my vb code and I want to be able to step into the
stored procedure and debug it. I have heard of SQL debugger, but don't know
to enable it in the vb.net environment in order to be able to step into a
stored procedure.

Regards,
kd.
 
G

Guest

You cannot debug a stored procedure by executing the stored procedure from
the 'ExecuteNonQuery' method.
You can only debug the stored procedure directly from the IDE. To debug the
stored procedure, you have to set the breakpoints in a stored procedure by
opening the procedure from the server explorer, and then right-click the
stored procedure in the server explorer, and click "Step Into Stored
Procedure".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

debugging an SQL Server 2000 stored procedure... 1
Newbie Question on parameters passed to stored procedure 9
Crystal Report with Stored Procedure 1
Invalid Column Name Sql-Error :Executing a stored procedure 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Batch file - additional input lines to called program 2
debugging stored procedure 2
Calling an Oracle Stored Procedure with parameters 1

Top