question

Chris 2 avatar image
Chris 2 asked

Oracle update in SQL 2012 SSIS SQL task

Hi, MS SQL 2012 SSIS on Windows 2008R2. Run into an error of "Error: ORA-00911: invalid character" on Oracle update statement in SQL task step. Oracle update: UPDATE table1 SET Status = 'C' WHERE name IN (SELECT name FROM table2) AND Status IS NULL; UPDATE table3 SET Status = 'C' WHERE Name IN (SELECT RoleName FROM ML_Role) AND Status IS NULL; what did I miss? Thanks. Chris
sql2012
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
At a glance, they look okay. What happens when you run the commands in SQL*Plus? You might also try using quoted identifiers - maybe the Oracle tables were initially created with double quotes?
0 Likes 0 ·

1 Answer

·
Sule avatar image
Sule answered
Try to remove semicolon (;) at the end of each statement.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.