Advertisement

05.03.2008 at 08:44PM PDT, ID: 23374520
[x]
Attachment Details

OCI block invalid character

Asked by jasonlivesay in C Programming Language, Oracle Database, C++ Programming Language

Trying to call OCIStmtExecute with several statements e.g. create table ...; create sequence ...; ...
Getting invalid character on the semicolon.
Is there some parameter for OCIStmtExecute or OCIStmtPrepare that will allow me to include an anonymous PL/SQL block (using ; to separate statements)? Or is there some other character instead of ; I can use?
This is actually using the ORAPP library.  The call is :
_errno = OCIStmtExecute(_svc, _stmt, _err, (ub4)(_type != OCI_STMT_SELECT), 0, NULL, NULL, _execmode);
I'm on Windows using OCI version 10.2.0.3.  (oci.lib)
ThanksStart Free Trial
 
Loading Advertisement...
 
[+][-]05.03.2008 at 09:37PM PDT, ID: 21494576

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: C Programming Language, Oracle Database, C++ Programming Language
Sign Up Now!
Solution Provided By: jasonlivesay
Participating Experts: 0
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628