Using SSIS to execute Oracle Procedure

• rka

  SSCommitted

  Points: 1599

  More actions

  July 17, 2012 at 5:27 am

  #143653

  I have a Oracle stored procedure with 4 input parameters. The procedure then inserts data into a table. I am using Oracle Provider for OLE DB.

  I am trying like to execute this procedure from a SSIS OLEDB Command. The SQLCommand that I use is:

  {CALL TEST.LOAD_DIM_COST_CENTRE_IM}

  When I execute the package, i get an error:

  [CMD - Dim_Cost_Centre Create inferred member [2208]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.

  An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80040E14 Description: "ORA-06550: line 1, column 7:

  PLS-00306: wrong number or types of arguments in call to 'LOAD_DIM_COST_CENTRE_IM'

  ORA-06550: line 1, column 7:

  PL/SQL: Statement ignored".

  Can anyone please help me to resolve this issue?

  Thanks

• Rocky's

  Ten Centuries

  Points: 1102

  More actions

  July 17, 2012 at 5:54 am

  #1513530

  check the datatypes of the Parameters...you have to make sure that the datatypes should be compatible