Post reply

Error while calling Oracle Stored procedure!

  • March 19, 2008 at 9:09 am

    #379326

    Hi pals,

    I am facing problems while calling Oracle stored procedure which has no parameters.

    I have used Microsoft OLE DB provider for Oracle.

    I have taken one Execute SQL task and set the SQLStatement as

    call procedurename

    I also set the IsStoredProcedure property to True for Execute SQL task.

    Is there any synatx problem?

    I am getting an error saying

    Error: 0xC002F210 at Call Sp, Execute SQL Task: Executing the query "(call sp_procname)" failed with the following error: "ORA-00928: missing SELECT keyword.

    I removed the curly braces for the SQL statement and again ran the Package, i am getting the below error

    Executing the query "call sp_procname" failed with the following error: "ORA-06576: not a valid function or procedure name

    Can anyone help me out on this regard!

    Thanks in advance

  • March 19, 2008 at 8:15 pm

    #791841

    The first thing I would bedoing is to go and check if the Oracle Stored Procedure is in fact compiled without any errors in the Oracle Database.

    If it's compiled, then execute within Oracle to ensure that the Stored Procedure actually completes without error and that it does what its suppose to do.

    Do that and get back to us with the outcome.

    Kindest Regards,

  • March 20, 2008 at 1:27 am

    #791870

    Hi Guys,

    There is no problem with user permissions.

    It is perfectly working fine in Oracle.

    Only thing is that i was unware of syntax of calling oracle stored procedure.

    Here is the solution

    {call procedurename}

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply