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

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

    pl_sequel

      Hi all,

       

      Running on Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 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:
        oradb:/DB-SCHEMA/TABLE/ 

        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.

       

      Bug?