SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select from dba_directories in pl/sql procedure

655260Sep 5 2008 — edited Mar 28 2013

hello,

I tried to do this in a procedure but got an error:

-----

select count(*) into ocount from dba_directories where directory_name = 'DIR0001';

-----

error: table or view does not exist.

Would someone suggest where this table can be found?

Thank you.

This post has been answered by Solomon Yakobson on Sep 5 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 25 2013

Added on Sep 5 2008

6 comments

11,153 views