Page 1 of 1

DBMS_OUTPUT.PUT_LINE privilege

Posted: Sun 16 Dec 2018 23:47
by mazin1390@gmail.com
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?

Re: DBMS_OUTPUT.PUT_LINE privilege

Posted: Mon 17 Dec 2018 15:44
by alexa
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 .