• 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