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 so
Fermin...:
ORA-01403 means No data found...
you should manage an EXCEPTION code in your procedure
to catch this kind of error.
HTH
JL
--- Fermin Bernaus <[EMAIL PROTECTED]> wrote:
>
> I get ORA-01403. I have no clue why I am getting
> this error, can you help please?
>
> Many tha
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
bash-2.05a$ oerr ora 1403
01403, 0, "no data found"
// *Cause:
// *Action: Make up some data. Use your imagination
--
Mladen Gogala
Oracle DBA
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Fermin Bernaus
> Sent: Tuesday, September 09, 2003