e.g.
Toad for Oracle -> Database -> Schema Browser -> Click HR -> Click Procedures -> Double click to "PROC_EXEC" procedure -> Set breakpoint or Add Watch (optional) -> Press Shift+F7 or Click Debug-Trace Into -> Confirm -> Click Execute
Showing posts with label debug. Show all posts
Showing posts with label debug. Show all posts
Friday, 2 February 2018
Friday, 19 January 2018
How to use "Toad for Oracle" Help?
e.g.
Toad for Oracle -> Help -> Contents -> Search "Debugging a Procedure or Function Tutorial"
Toad for Oracle -> Help -> Contents -> Search "Debugging a Procedure or Function Tutorial"
Tuesday, 29 November 2016
How to enable debug mode?
SQL> GRANT DEBUG CONNECT SESSION TO hr;
SQL> GRANT DEBUG ANY PROCEDURE TO hr;
Lastly, reconnect to the session and try again :)
SQL> GRANT DEBUG ANY PROCEDURE TO hr;
Lastly, reconnect to the session and try again :)
Subscribe to:
Posts (Atom)