Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

REP-1401: 'afterpform': Fatal PL/SQL error occurred

user5345Sep 18 2011 — edited Sep 21 2011
Dear All,

Im using the below code in report 10g "after parameter form" trigger and which is giving me error:

IF :P_TYPE = 'Govt' THEN
:LP_TYPE := 'and rctt.cust_trx_type_id in (''1062'', ''1063'')';
END IF;


Error:
REP-1401: 'afterpform': Fatal PL/SQL error occurred.
ORA-06502: PL/SQL: numeric or value error

Can any one tell me the above code used the correct syntax.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2011
Added on Sep 18 2011
#reports
10 comments
3,906 views