rep1401 Fetal PL/SQL error occured [message #653547] |
Sun, 10 July 2016 23:38 |
|
7anona
Messages: 72 Registered: February 2012
|
Member |
|
|
Good morning every one
please help me with this issue
I'm having this function on my report
function CF_4Formula return Char is
a varchar2(100);
begin
select NVL(bin_loc,'***') into a from supl.sp_t006auto where item_code=:item_code and
store_code=:storecode;
return a;
end;
the column size in the database is 15 and the column
in my report calling the function is 100
I'm getting the error:
rep:1401 'cf_4formula':Fetal PL/SQL erroe occured
Ora-01722: invalid number
|
|
|
|
|
|
|