May 9, 2008 at 7:21 am
I am trying to execute an Oracle stored procedure from within SSIS Execute SQL Task and am getting the following error:
[Execute SQL Task] Error: Executing the query "exec MASTER.truncate_table_PR('DLZ_TBLENTITY_STG')" failed with the following error: "ORA-00900: invalid SQL statement ". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
I have confirmed the syntax is valid and is Oracle syntax. The connection is valid and I have the permissions to run the stored proc.
Can somebody help please? The call is exec MASTER.truncate_table_PR('DLZ_TBLENTITY_STG')"
Thanks!
Karen
October 6, 2014 at 5:37 am
Can be FIXED when surrounded with BEGIN..END statements: -
for e.g., my procedure name in Oracle is dp_tfr, then I will write like below: -
BEGIN
dp_tfr;
END;
below methods will fail: -
just gave the dp_tfr in the sql area and got below message:
[Execute SQL Task] Error: Executing the query "dp_tfr"
failed with the following error: "ORA-00900: invalid SQL statement".
Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
when tried using the declare begin end block, got below message
DECLARE seq_id_val number;
BEGIN
seq_id_val := 0;
exec dp_tfr ;
END;
[Execute SQL Task] Error: Executing the query "declare
lv_cnt number;
begin
execute dp_tfr" failed with the following error: "ORA-06550: line 4, column 10:
PLS-00103: Encountered the symbol "DP_TFR" when expecting one of the following:
:= . ( @ % ; immediate
The symbol ":=" was substituted for "DP_FTDO_BHHD_EMLAP_TFR" to continue.
". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Regards,
Rakesh
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply