SSIS Execute SQL Task executes but perform's no inserts with Oracle

• MikeLPlates

  Say Hey Kid

  Points: 662

  More actions

  September 5, 2014 at 3:34 am

  #310698

  Okay

  Forgive me if someone else has come across this. I couldn't find anything in the forum.

  The scenario is that I'm running an Execute SQL Task connecting to an Oracle 11.2 database in Bids. The task runs but performs no activity. The code being executed, (anonymous sql) successfully works on the same database in SQL Developer (with inserts).

  Turned out, I think, to be the method of commenting within the Oracle PL/SQL. This was using the single line comment indicator "--".

  When I removed some comments, and executed the task the Task failed with.....

  ORA-06550: line 1, column 5555:

  PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

  The amended code still worked in SQL Developer.

  I then amended the relevant comments to use the block comment ( /* and */) and the task successfully executed performing the required inserts.

  Hope this helps.

  Regards