Re: pl/sql simple prob but .....
From: Fernando Luna <fern_at_aa.net>
Date: 1996/02/06
Message-ID: <4f6p2s$6v7_at_Holly.aa.net>#1/1
Date: 1996/02/06
Message-ID: <4f6p2s$6v7_at_Holly.aa.net>#1/1
In article <310FA8A1.6C0B_at_amoco.com>, srnathan_at_amoco.com says...
>
>Ravi Rai wrote:
>> compilation Error:
>> 15/10 PLS-00356: 'LP_VAL.TABLE_NAME' must name a table to which
the
>> user has access
>>
>> ----
>>
>> Thanks
>>
>> RaviTry using dynamic sql.
It mihght also help to see if you have access to the table, or just fully qualify it... (ie: SYSTEM.USER_TABLES... or maybe try the view ALL_TABLES...) Maybe I'm oversimplifying the problem but your error message suggests that you don't have access to the table... Received on Tue Feb 06 1996 - 00:00:00 CET