rep1401 Fetal PL/SQL error occured [message #653547] |
Sun, 10 July 2016 23:38 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/094b69ece6712bf79d71cf8a9b9f5bd7?s=64&d=mm&r=g) |
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
|
|
|
|
|
|
|