DiigIT | IT Community
No Profile Image
Welcome Guest
New User? Register | Login
IT Tags
DiigIT » Oracle »

DBMS_OUTPUT works in PUBLIC SYNONYMS not otherwise....

By: | 15 Apr 2011 10:39 pm

I have a procedure that outputs just 1 line (put_line)

I have given access to other users to execute this. But they are able to execute it and not see results even when they set serveroutput on. However, when I create a public synonym for the same procedure, it works fine.

Any idea why?

 

Comments

No Comments Posted for this Article.

Leave a comment

Enter the text in the image
img
Can't read?
Type the characters you see in the picture below.


Close Move