3 Replies Latest reply: Aug 8, 2013 12:40 PM by Marco Gralike RSS

    ora-00942 when querying using "PUBLIC" schema in fn:collection


      Hi all,


      Running on Oracle Database 11g Enterprise Edition Release - 64bit Production


      Tried using the "PUBLIC" schema in my fn:collection oradb call, but I am getting an ora-00942 error. Based on the documentation:


      The format of the URI argument passed to fn:collection is as follows:

      • For an XMLType or relational table or view, TABLE, in database schema DB-SCHEMA:

        You can use PUBLIC for DB-SCHEMA if TABLE is a public synonym or TABLE is a table or view that is accessible to the database user currently logged in.

      The table in question is local to the user i am logged in as. The only way i could get this to work was to grant select to public on the table and create a public synonym.