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

On 07 Mar 1998 20:08:59 +0100, Terje Sannum <ts_at_nextel.no> wrote:

>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.

That's sort of the whole purpose behind having a procedure. If we only needed one value we would only have functions. Received on Sun Mar 08 1998 - 00:00:00 CST