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!

Unable to fetch from all_directories ORA-12801: error signaled in parallel query server P000

968361Jul 10 2015 — edited Jul 29 2015

Hi All,

I am facing an error in oracle 12 c version 12.1.0.2.0 database

whenever I query

select directory_name

from all_directories

where directory_path = 'D:\incoming_if\IN_DIR' || global.slash || 'wip'

Getting error:

ORA-12801: error signaled in parallel query server P000

ORA-01006: bind variable does not exist

global.slash is function that will return '\'.

When I create a temporary table and insert the same value. The query returns with out any errors. But the moment I fire the query on all_directories I get the error. I am trying to figure out this issue and it would be of great help if some one has faced the same issue and give me some guidence.

Regards

-Vinod

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 26 2015

Added on Jul 10 2015

16 comments

2,775 views