Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL - IN OUT PARAMETER problem: ORA-06502: PL/SQL: Numeric or value error

Re: PL/SQL - IN OUT PARAMETER problem: ORA-06502: PL/SQL: Numeric or value error

From: Terje Sannum <ts_at_nextel.no>
Date: 1998/03/07
Message-ID: <w01zweqpx0.fsf@terje.nextel.no>#1/1

Alexander Day <ajd_at_sqlsystems.dk> writes:

> I am an ORACLE developer, currently developing an Intranet system,
> and I have run into a problem with IN OUT parameters in stored
> procedures. The problem is that when you call the procedure from a
> URL, the length of the IN OUT parameter is determined from what you
> pass as the actual parameter value. This means that when it comes
> time to assign a NEW value to the parameter in your procedure (since
> it is an IN OUT parameter), if the NEW value's length is greater than
> that of what was passed in, you receive a "ORA-06502: PL/SQL: Numeric
> or value error" error message. Most irritating. I assume that this is
> a bug. Has anyone else had this problem and, even more importantly,
> is there a solution/patch/workaround to this?

I'm not suprised that this is not working. It doesn't make any sense to have in/out parameters to the procedures called by the PL/SQL agent. Where should that out data go?

The PL/SQL agent has not called your procedure with a value as the parameter, not a variable. Therefore it has no place to store the new value you want to set in the procedure.

-- 
\\\\ Terje Sannum <ts_at_nextel.no>
//// Now playing: Sheep On Drugs / Greatest Hits
Received on Sat Mar 07 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US