FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06550.
478885Dec 26 2005 — edited Dec 26 2005Dear friends:
I'm using the Forms 4.5 (Designer) to design a form.
There is a trigger( when-button-pressed ) of the button, when I run the form and presse the button, it will show the problem like the subject. Pls kindly help me to fix it. Thanks.
There is a procedure that the button trigger will call it, and then, when run to here, that wil be the problem.
Attached the procedure declare for your referrence.
The trigger:
declare
sMsg varchar2(200);
nSeverity number;
sContract_nbr varchar2(20);
sContractor_name varchar2(100);
sWorks_order_type varchar2(2);
sWorks_order_status varchar2(2);
sDestPath varchar2(255);
sCommand varchar2(255);
nRecCount number;
sTempPath varchar2(255);
nChk number;
begin
......................
pack_order_extraction_paul.extract_ENQ0171( sMsg, nSeverity,nRecCount, :parameter.par_oracle_file_path,:parameter.par_temp_file, 'CSV', sContract_nbr,sworks_order_type,sworks_order_status,sContractor_name);
........................
The Procedure:
procedure extract_ENQ0171
( io_sMsg in out VARCHAR2, io_nSeverity in out number, io_nRecCount in out number,sFilepath VARCHAR2, sFilename VARCHAR2, sFileFormat VARCHAR2,scontract_nbr VARCHAR2, sworks_order_type VARCHAR2, sworks_order_status VARCHAR2,scontractor_name VARCHAR2
)
................