Home » Developer & Programmer » Reports & Discoverer » rep1401 Fetal PL/SQL error occured (10g R2)
rep1401 Fetal PL/SQL error occured [message #653547] Sun, 10 July 2016 23:38 Go to next message
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
Re: rep1401 Fetal PL/SQL error occured [message #653548 is a reply to message #653547] Mon, 11 July 2016 00:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

More likely there is some data in item_code or store_code that is not a number when your variables are declared as numbers.

Re: rep1401 Fetal PL/SQL error occured [message #653550 is a reply to message #653548] Mon, 11 July 2016 00:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

... or "bin_loc" column is declared as a number.

Re: rep1401 Fetal PL/SQL error occured [message #653552 is a reply to message #653550] Mon, 11 July 2016 01:34 Go to previous messageGo to next message
7anona
Messages: 72
Registered: February 2012
Member
Thank You the Problem is solved
Re: rep1401 Fetal PL/SQL error occured [message #653555 is a reply to message #653552] Mon, 11 July 2016 02:27 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And the problem was and the solution is?

[Updated on: Mon, 11 July 2016 02:28]

Report message to a moderator

Previous Topic: Disable PDF RTF on runtime
Next Topic: Printing tab character
Goto Forum:
  


Current Time: Thu Mar 28 06:30:44 CDT 2024