Re: Unable to Read table in STORED PROCEDURE

From: Mark & Kristi Wagoner <mwagoner_at_iac.net>
Date: Thu, 7 Feb 2002 22:35:50 -0500
Message-ID: <a3vh2m$c5r$1@genma.iac.net>

All tables are created under someone's schema, even if it is SYS.

My guess is you are accessing it through a role in SQL which is not being activated in the stored procedure. Either create the procedure as the owner of the table or grant select on the table directly to yourself.

"Rich" <abc_at_email.com> wrote in message
news:6KF88.20133$5K1.3327457_at_news20.bellglobal.com...
> I am trying to SELECT from a table within my Stored procedure but
> it was unable to compile and complained about view or table not found.
>
> This table was not created under someone's ID. However, I was able to
SELECT
> from it on the command line, like isql.
>
> The problem only happens in the stroed procedure.
>
> Any ideas?
>
> Please email to rkwok_at_sympatico.ca
>
> Thanks in advance
> Vicky
Received on Thu Feb 07 2002 - 21:35:50 CST