Oracle Forms (MOSC)

MOSC Banner

A PL/SQL package returning white spaces as char out parameter to the form cauing ORA-06502(PL/SQL: n

edited Oct 23, 2012 2:05AM in Oracle Forms (MOSC) 5 commentsAnswered
Hello All,

I have a PL/SQL package which has out parameter as char and inside the package i'm assigning white spaces to that parameter. Now, when i'm calling the package in oracle form it is causing ORA-06502(PL/SQL: numeric or value error) error, receiving item in the form has char datatype and has same length .  As a work around in the form if i'm receiving the value from package to a variable of char datatype with same width and then assigning to the item is working fine. I'm using Oracle Forms 11gR2 and Oralce 11.2.03 database. Any help is highly appreciated.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center