execute oracle procedure from SSIS

[From]: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8a5998f5-2dad-4634-9be1-24cdbb74fb39/execute-oracle-procedure-from-ssis?forum=sqlintegrationservices

well I found a workaround. instead of using pure SQL you can use plain PL/SQL code to execute the procedure.

so instead of ‘execute procABC’ just use

begin
procABC;
end;

It works perfectly fine. 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s