A PL/SQL package returning white spaces as char out parameter to the form cauing ORA-06502(PL/SQL: n
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.