We are running:
- Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
- Forms [32 bits] Versión 9.0.4.0.19
- PL/SQL Developer Version 7.1.5.1398 150.44103 - 50 user license
Hi there,
We are developing an application with Oracle Forms in which we are using a hierarchical tree with SYS_CONNECT_BY_PATH function that works correctly in our system . This hierarchical tree needs to be called from another application in another squema. We have decided to use dblinks. It doesn't work. We have checked the table permissions and they look ok. We have tried to query from the other squema using the dblink to a table, and the dblink works. So, we took out the hierarchical tree to a PLSQL Developer Editor to work with it and the pop up we are getting says:
ORA-30002: SYS_CONNECT_BY_PATH function is not allowed here
ORA-02063: preceding line from DBName's
Can anyone help us?
Regards.