Tuesday, August 17, 2010

Debug Oracle function/stored procedure

1. Login as DBA
2. GRANT debug any procedure, debug connect session TO xxx;
3. Login as xxx user
4. Use "Oracle SQL Developer" to debug, you need to write a simple PL/SQL client to invoke the function/stored procedure, you can set break-point somewhere.

No comments:

Post a Comment