Stored_Procedure_0,0: Operator terminated abnormally: receiv

[jimgowtham]

Hi,

I have used Stored Procedure stage in parallel jobs to run the stored procedure "PR_PROCEDURE_LOG".

Procedure name : PR_PROCEDURE_LOG
==================================

CREATE OR REPLACE PROCEDURE GPM_STG_ETL.pr_procedure_log(p_procedure_name IN VARCHAR2,
p_action_type IN VARCHAR2,
p_error IN VARCHAR2,
p_user IN VARCHAR2) AS
BEGIN

INSERT INTO MD_STG_PROCEDURE_LOG
(PROCEDURE_NAME, ACTION_TIME, ACTION_TYPE, ERROR, UPDATE_BY)
VALUES
(UPPER(p_procedure_name),
SYSTIMESTAMP,
p_action_type,
p_error,
p_user);
COMMIT;
END pr_procedure_log;
/



My DS_JOB director log :
========================

Stored_Procedure_0,0: Info: Stored_Procedure_0: BEGIN PR_PROCEDURE_LOG(); END;
Stored_Procedure_0,0: Operator terminated abnormally: received signal SIGBUS
main_program: Step execution finished with status = FAILED.


I have used search option in DSXchange and found solution as

"APT_DISABLE_COMBINATION =true"

Even after using this "APT_DISABLE_COMBINATION", job is aborted with fatal error as..

Stored_Procedure_0,0: Operator terminated abnormally: received signal SIGBUS


Thanks & Regards,
JIM

[ray.wurlod]

Verify that you provided four argument values of appropriate data type to the stored procedure via the Stored Procedure stage.

Does the Stored Procedure stage expect a return value?

[keshav0307]

modify your procedure to return a success/failure flag.
handle the exception in case the insert fail, return a failed flag.

[jimgowtham]

I tried using four parameters in SP stage...

P_PROCEDURE_NAME VARCHAR2(200);
P_ACTION_TYPE VARCHAR2(200);
P_ERROR VARCHAR2(200);
P_USER VARCHAR2(200);

After the changes, now I am getting the fatal error like...

Stored_Procedure_0,0: Operator terminated abnormally: received signal SIGSEGV
main_program: Step execution finished with status = FAILED

This SP is running successfully in TOAD, However it is not not running through SP stage in Datastage.


Regards,
JIM

[keshav0307]

post the modified procedure?
what does the procedure returns??
have you handled the exceptions??

[chulett]

One simple 'solution' would be to use an Oracle stage for this, insert it directly. Why futz with a stored procedure just to insert a single record to a table?

If it is meant to be reusable across jobs, put it in a Shared Container.

[jimgowtham]

Thank you Very Much...