SSIS can't work with Oracle procedure with OUTPUT param sysrefcursor

[daliborl]

Hi, I have a little bit problem with SSIS and executing Oracle procedure with OUTPUT param sysrefcursor.
This procedure return one column with 200 rows through sysrefcursor. I try to make this but unsuccessful.
In sql task editor in sql statement I put:
begin procedure ? OUTPUT; end; also set full result
And in parameter mapping i put OUTPUT param VARCHAR, variable is type Object.
Can somebody same expiriance?

 

[fredericofonseca]

see this

http://social.msdn.microsoft.com/Fo...ameter-from-ssis?forum=sqlintegrationservices

one other way is to call yet another package which executes the first one and inserts the data into a table - and then you do a normal table extract

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886