Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SP2-0226: Invalid line number

PSULionRPApr 3 2009 — edited Apr 3 2009
I have a SQL Script that looks like this...

/*Tracker Ticket TR12345 - UPDATE rows in Oracle table
UPDATE the column for the following key_row_seq rows:

0001
0002
0003

*/

--TR12345 - Non Standard Data Repair to Update Table

UPDATE Table A
SET A.column = 'WEBIU2'
WHERE A.ky_row_seq IN
(0001,
0002,
0003)

/


When this SQL ran, it gave me a "SP2-0226: Invalid line number" error on the block commented lines within the /*...*/ comment block. Why???

The errors look like this...

SQL> 0001
SP2-0226: Invalid line number
SQL> 0002
SP2-0226: Invalid line number
SQL> 0003
SP2-0226: Invalid line number


I appreciate any feedback and Thank in advance for your review and help.

PSULionRP
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2009
Added on Apr 3 2009
3 comments
3,682 views