Unless the stored procedure was created with invoker's rights, then it is probably executing using the permissions and schema of the account that owns it. Who is the owner of the stored procedure? Is it different from who you are logged into SQL*Plus as?
The explanation might be that, through some reason like synonyms pointing in different directions from the different accounts, the name TTDSLS805501 might be resolving to different tables altogether... on 9/9/03 10:09 AM, Fermin Bernaus at [EMAIL PROTECTED] wrote: > > If logged in SQL Plus the following SQL returns just one row: > > SELECT t$orno FROM ttdsls805501 WHERE t$user = 'exped9' GROUP BY t$orno; > > If I do use the same SELECT statement inside a stored procedure and have the > returning value stored in a local variable: > > SELECT t$orno INTO eskaria FROM ttdsls805501 WHERE t$user = 'exped9' GROUP BY > t$orno; > > where eskaria has been declared as: > > eskaria ttdsls805501.t$orno%TYPE; > > I get ORA-01403. I have no clue why I am getting this error, can you help > please? > > Many thanks! > > ............................................. > Fermín Bernaus Berraondo > Dpto. de Informática > SAMMIC, S.A. > [EMAIL PROTECTED] > http://www.sammic.com > Telf. +34 - 943 157 331 > Fax +34 - 943 151 276 > ............................................. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
