Home » SQL & PL/SQL » SQL & PL/SQL » Using debug in EBS r12 database with SQL Developer (ORACLE EBS R12)
Using debug in EBS r12 database with SQL Developer [message #660912] Wed, 01 March 2017 00:18 Go to next message
annu-agi
Messages: 238
Registered: July 2005
Location: Karachi
Senior Member

DEAR EXPERTS

How can one use SQL developer debug option within ORacle EBS r12 database.
when ever i do use debug it shows
Connecting to the database BCL-PROD.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '10.1.3.1', '53955' )
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
This session requires DEBUG CONNECT SESSION and DEBUG ANY PROCEDURE user privileges.
Process exited.
Disconnecting from the database BCL-PROD.


By the way i am connecting with apps user



regards


Anwer Ali
Re: Using debug in EBS r12 database with SQL Developer [message #660914 is a reply to message #660912] Wed, 01 March 2017 01:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And the question is?

Re: Using debug in EBS r12 database with SQL Developer [message #660918 is a reply to message #660914] Wed, 01 March 2017 03:24 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Sounds like the app user doesn't have the privs mentioned in the error message. So grant them to the apps user.
Re: Using debug in EBS r12 database with SQL Developer [message #660950 is a reply to message #660918] Thu, 02 March 2017 08:05 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
LOL. One of the clearer oracle errors. They are normally a lot less clear.
Re: Using debug in EBS r12 database with SQL Developer [message #660957 is a reply to message #660912] Thu, 02 March 2017 09:53 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And feedback in this topic and the previous ones.

Previous Topic: {} in SQL
Next Topic: Convert select query to a cursor and that has to fetch first record
Goto Forum:
  


Current Time: Thu Mar 28 07:44:35 CDT 2024