OraFAQ Forum: SQL & PL/SQL » Using debug in EBS r12 database with SQL Developer

Home » SQL & PL/SQL » SQL & PL/SQL » Using debug in EBS r12 database with SQL Developer (ORACLE EBS R12)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Using debug in EBS r12 database with SQL Developer [message #660912]

Wed, 01 March 2017 00:18

annu-agi
Messages: 239
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

Report message to a moderator

Re: Using debug in EBS r12 database with SQL Developer [message #660914 is a reply to message #660912]

Wed, 01 March 2017 01:04

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And the question is?

Report message to a moderator

Re: Using debug in EBS r12 database with SQL Developer [message #660918 is a reply to message #660914]

Wed, 01 March 2017 03:24

cookiemonster
Messages: 13975
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.

Report message to a moderator

Re: Using debug in EBS r12 database with SQL Developer [message #660950 is a reply to message #660918]

Thu, 02 March 2017 08:05

Bill B
Messages: 1971
Registered: December 2004

Senior Member

LOL. One of the clearer oracle errors. They are normally a lot less clear.

Report message to a moderator

Re: Using debug in EBS r12 database with SQL Developer [message #660957 is a reply to message #660912]

Thu, 02 March 2017 09:53

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And feedback in this topic and the previous ones.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 14 12:15:52 CDT 2026