Getting error - ora-01003 no statement parsed
798481Oct 26 2010 — edited Oct 28 2010Hi,
I have customized a form and added below query in pre-insert trigger on friday. For the past 4 days it was working fine and now if we try to save that form, we are getting the error "ora-01003 no statement parsed"
Find below the query added in the pre-insert trigger:-
DECLARE
BEGIN
INCIDENT_TRACKING_LIB.Pre_Insert;
Q_TXN.event('PRE-INSERT','INCIDENT_TRACKING');
INSERT INTO cmw_bc_mobile_number select :incident_tracking.account,:INCIDENT_TRACKING.ERROR_CODE,SYSDATE from dual
WHERE not exists (select * from cmw_bc_mobile_number
where customer_number=:incident_tracking.account);
END;
Please can anyone help me in resolving this issue.
Regards,
Raj