Hi Fermin,
given that I understand you correctly:
pl/sql DOES exactly what you want:
it returns 0 rows. That results in a exception
called NO_DATA_FOUND and is assigned
to the ORA-01403 error.
To get a result '0' you have to query
the table using 'Count'.
Greetings,
Guido
[EMAIL PROTECTED]
Fermin,
The pl/sql manual has an appendix on char versus varchar2 semantics.
I guess SQL*Plus isn't as restrictive(?) and I gues the behaviour might
have changed since 7.3.
I wonder why baan uses char datatypes
chaim
Guido Konsolke [EMAIL PROTECTED]
@fatcity.com on 09/10/2003 10:14:24 AM