Home » Developer & Programmer » Reports & Discoverer » afterpform': Fatal PL/SQL error occurred, PL/SQL: numeric or value error (2 threads merged by bb)
afterpform': Fatal PL/SQL error occurred, PL/SQL: numeric or value error (2 threads merged by bb) [message #661331] Tue, 14 March 2017 23:20 Go to next message
nugraha.perdana2390
Messages: 4
Registered: March 2017
Junior Member
Hi All,
I am facing a problem in running custom report.

this query:
function AfterPForm return boolean is
begin
begin
if :p_receive = 'FULL' then
:p_where_rcv := 'and rcv.transact_qty = prp.po_qty';
else if :p_receive = 'PARTIAL' then
:p_where_rcv = 'and prp.quantity_received <> prp.po_qty
and rcv.rcv.transact_qty is not null'
end if;
end if;
return (TRUE);
end;
end;

when I add "and rcv.rcv.transact_qty is not null" There is a problem report

pleace help me..
Re: afterpform': Fatal PL/SQL error occurred, PL/SQL: numeric or value error (2 threads merged by bb) [message #661334 is a reply to message #661331] Wed, 15 March 2017 02:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From your previous topics:


Michel Cadot wrote on Thu, 09 March 2017 07:45

Welcome to the forum.
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Also always post your Oracle version, with 4 decimals, as solution depends on it.

BlackSwan wrote on Tue, 14 March 2017 03:56
Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

[Updated on: Wed, 15 March 2017 02:14]

Report message to a moderator

Re: afterpform': Fatal PL/SQL error occurred, PL/SQL: numeric or value error (2 threads merged by bb) [message #661335 is a reply to message #661334] Wed, 15 March 2017 04:23 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
What size is p_where_rcv defined as?

And why have you got rcv.rcv. ?
shouldn't it just be rcv. ?
Previous Topic: REP-1401: 'afterpform': Fatal PL/SQL error occurred. ORA-06502: PL/SQL: numeric or value error
Next Topic: Oracle Report
Goto Forum:
  


Current Time: Thu Mar 28 10:29:45 CDT 2024