Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

debug procedure with pl/sql

Status
Not open for further replies.

IBI

IS-IT--Management
Jun 13, 2002
76
0
0
DE
Hi,
when I try debug a pl/sql procedure (dx add debug information) I receive the following message :

Unable to initialize debugger.
Note: Debugging is only available on Oracle 7.3.4 or later.

client: 10.2.0.1.0 server : W2003 oracle 10.1.0.2.0

Any ideas ?
Thanks
ibi
 
PROVE WITH THIS
GRANT DEBUG CONNECT SESSION TO <USER>;
 
I had de same problem. to debug, the app create a second session this session is a debug session if can't create this session then the dbms_debug package throw exception then the app thinks that not exist this package and believe than is older version of Oracle.
you need connect with sys and execute this
GRANT DEBUG CONNECT SESSION TO <USER>;
sorry , my level of english is very poor.
 
David,

Don't worry about your English...we appreciate your contributions here, regardless of English proficiency. (How good do you think my Estonian is? <grin>)

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm. The cost will be your freedoms and your liberty.”
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top