I am using TOAD and I get an ORA-00911 error on the first semicolon.
I tried the following...
INSERT INTO MYTABLE (CCN, PRJ) VALUES ('100', '5102566');
INSERT INTO MYTABLE (CCN, PRJ) VALUES ('100', '1000238');
commit;
I'm not able to execute it as a filename.sql script file because I'm using a Web server via ColdFusion to execute the SQL Statement that are programmatically generated.
You may need to put a carriage return in-between the two statements to run them using the "Run the current statement" icon. It's a TOAD thing. Otherwise in TOAD you can run both using the two arrows icon (one above the other) which will run everthing in your window as a script.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.