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!

sys_connect_by_path over db link causes ora-29900

5540Apr 11 2005 — edited Apr 11 2005

I have a query that uses sys_connect_by_path. It works fine when run from the database where the table resides. When I try to run the same query from another database over a db link, I get the following error:

ora-29900: operator binding does not exist
ora-06553: pls-306: wrong number or types of arguments in call to 'PATH'

Any ideas? Workarounds?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 9 2005

Added on Apr 11 2005

1 comment

189 views