to use package is any priv needed ?

[kdeepa]

hi! all,

Is any privilege needed to access packages.for eg,
if i use dbms_output.put_line,i get the err msg as
identifier dbms_output.put_line must be declared.

deepa.

 

[sem]

Yes, you need a priledge, but in most cases it's granted to PUBLIC. Another possible reason is lack of (PUBLIC) synonym, though in this case you still may call it as sys.dbms_output.

 

[jee]

Try having someone who can connect as SYS to grant execute on DBMS_OUTPUT to your userID.