Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Statements through ODBC or SQL 3.3 like batch. How???
Hi!
I wish to execute 2 statements through ODBC or SQL 3.3 as a batch.
I wish to execute two statements like "insert blah into blah; insert more blah into another blah". My platform is 7.3 NT based. I would like to use ODBC and ";" delimited statements.
I have tried, without success, various methods to obtain batch like processing through ODBC or SQL 3.3. I have attempted to use input logic in SQL 3.3, and the syntax checker returns "sql statement not properly terminated". I have tried appending ";" after data is in the input buffer, and get "invalid character". I have tried to delimit the statements with CRLF, "/" and CRLF, and get "improper termination". I have tried to "get" a file into the input buffer with various permutations of delimitation, and received the same errors as when entered manually (cut and paste also fails).
I have managed to work around the problem somewhat. I use srvmgr23 and paste statements delimited by CRLF, "/" and CRLF. But as I have stated earlier, I would like to use ODBC and ";" delimited statements.
Any suggestions greatly appreciated.
R Received on Thu Apr 24 1997 - 00:00:00 CDT