-
Hi,
Our C program uses the following OCIfunction to execute SQL statements
and we always get the ORA-00911 error. Our SQL statement terminate by a semicolon.
OCIStmtExecute(mysvchp,
mystmthp,
errhp,
(ub4) iterations,
(ub4) 0,
(CONST OCISnapshot *) NULL,
(OCISnapshot *) NULL,
OCI_DEFAULT)
When we remove the ";" in our SQL statements we don't have this error.
My question is how the above function execute a SQL statement in the DB.
I know that in SQL*Plus you can't run a SQL statement with a ";"
i.e
select*
from test;
/
Thanks
mcl
-
typically in any database when using libraries to connect and run statements you never need the semicolon. in client programs like sqlplus, it needs to know when you're done typing and the statement is done. the libraries are executing one pre-prepared statement so you don't have to terminate it with the semicolon.
