Fermin,
Are you sure it is failing here? As Mladen said, 1403 is "No Data Found".
Do you have any other select statements in the Procedure?
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Tuesday, September 09, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L
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: Fermin Bernaus
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mercadante, Thomas F
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).
