I need to call a function from Oracle through Ole DB command in SSIS. I have made the SQL statement as SELECT GET_APPLICATION_ID(?) into ? FROM DUAL my incoming columns into this Ole db command are : POLICY NUMBER POD NUMBER DISPATCH DATE COURIER NAME TYPE 30040440201100 43750712666 25/06/2011 Blue Dart Branch 30040442201100 43750712644 25/06/2011 Blue Dart Customer 30000081201000 43750735685 25/06/2011 Blue Dart Branch 30000053201000 43750712655 25/06/2011 Blue Dart Branch 30040465201100 43750713086 25/06/2011 Blue Dart Customer But in the run time OLE db command is failed with the following error: [OLE DB Command 1 [20497]] Error: An OLE DB error has occurred. Error code: 0x80004005. Please help.

is the Select GET_APPLICATION_ID(?) into ? FROM DUAL dynamic query? I mean that could you run it with SQLDeveloper of oracle?http://www.rad.pasfu.com