| 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  |
 |
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  |
 |
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
|
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:56Please 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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
