This discussion is archived
1 Reply Latest reply: Jan 18, 2013 9:19 AM by rp0428 RSS

Type Table reference lost on Upgrading from 10g Express to 11g Express

985716 Newbie
Currently Being Moderated
Hi,

I have a problem regarding Type Table Referencing. I have a Type table in one schema and this table is referenced in a Stored procedure in another schema. This was working in 10g Express database.

On upgrading the 10g Express to 11g Express the reference by property of the Type table lost the reference of the Stored procedure of the other schema. The Stored Pocedure is now showing the error

PLS-00201: identifier "TEMP.TBL" must be declared

The "TEMP.TBL" is declared in another schema.

Please suggest as to which privilege should be given so that "TEMP.TBL" which is created in one schema can be used in another schema.

Thanks & Regards
Renjit
  • 1. Re: Type Table reference lost on Upgrading from 10g Express to 11g Express
    rp0428 Guru
    Currently Being Moderated
    Welcome to the forum!

    Your question isn't clear. Provide the specifics about your types, tables and procedure.

    What is a 'Type table'? How is that table referenced?

    One possibility is that there is a privilege missing.

    In stored procedures priviliges to objects (e.g. to tables) need to be granted directly to the user and not thru a role.

    So if the table is in the SCOTT schema and the user that owns the procedure is HR then HR needs to be granted privileges to the table directly
    GRANT SELECT ON SCOTT.EMP TO HR;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points