DBMS_OUTPUT.PUT_LINE privilege

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
mazin1390@gmail.com
Posts: 1
Joined: Sun 16 Dec 2018 23:38

DBMS_OUTPUT.PUT_LINE privilege

Post by mazin1390@gmail.com » Sun 16 Dec 2018 23:47

I’m using trail dbForge Studio 2018.
I’m trying to run this simple code

Code: Select all

DBMS_OUTPUT.PUT_LINE( 'Hello, world!' );
And I get this error

ORA-01031: insufficient privileges
ORA-06512: at "SYS.PBSDE", line 82
ORA-06512: at "SYS.DBMS_DEBUG", line 226
ORA-06512: at line 1

I even cannot run (x := 10;) statement, again, I get insufficient privileges error.
However, the same simple code works fine using the same user account in SQL Developer. So, I do not believe that I have a problem with my account privilege.
Can you help, please?

alexa
Devart Team
Posts: 2599
Joined: Fri 24 Jun 2011 14:17

Re: DBMS_OUTPUT.PUT_LINE privilege

Post by alexa » Mon 17 Dec 2018 15:44

Could you please perform the following:
1. Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. Reproduce the issue and send us the *.log file with the latest date from the directory:

Code: Select all

%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for Oracle\
You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

Post Reply