Re: ORA-06502. PL/SQL: Numeric or value error

HI Alexander,

        I've never run into this.... I'll have to check it out tho....

    Perhaps you may be abe to work around it by specifing separate IN and OUT
parameters.....Let me know!

Alex

Alexander Day wrote in message <34FFE840.F009979_at_sqlsystems.dk>...
>Help please!
>
>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?
Received on Fri Mar 06 1998 - 00:00:00 CST