From: [EMAIL PROTECTED]
Operating system: Red Hat Linux 7.3
PHP version: 5CVS-2003-02-06 (dev)
PHP Bug Type: OCI8 related
Bug description: OCIBindByName causes problem if more than one Oracle statements are
executed.
I have a script that combines various statements before it calls the
OCIParse or OCIExecute.
For instance
Begin
Insert into TABLEA(COLA, COLB, COLC) Values('VAL1', 'VAL2', 'VAL3');
Update TABLEB Set COLB = 'SOMEVAL' Where ROWID = :RID1
End;
when I call an OCIBindByName for :RID1 as
OCIBindByName($oci_stmt,":RID".$i,&$this->arr_rowid[$i],-1,OCI_B_ROWID);
where I've defined each subscript of arr_rowid using OCINewDescriptor
using the following
$this->arr_rowid[$i] =
OCINewDescriptor($this->obj_conn,OCI_D_ROWID);
OCIExecute gives me an error saying
Warning: OCIStmtExecute: ORA-06550: line 1, column 221: PL/SQL: ORA-00933:
SQL command not properly ended ORA-06550: line 1, column 93: PL/SQL: SQL
Statement ignored ORA-06550: line 1, column 224: PLS-00103: Encountered
the symbol "end-of-file" when expecting one of the following: begin case
declare end exception exit for goto if loop mod null pragma raise return
select update while with /var/www/html/crp/includes/dbconn.inc on line
333
I'm still investigating into the issue. Instincts tell me that the problem
is due to multiple statements in 1 query so am all up on changing the
entire class for all such occurances. However, the attempt to save
database time by executing multiple queries together seems like is not
destined to work. If it doesn't work, I'll get back in here with more
info.
--
Edit bug report at http://bugs.php.net/?id=22087&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=22087&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=22087&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=22087&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=22087&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=22087&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=22087&r=support
Expected behavior: http://bugs.php.net/fix.php?id=22087&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=22087&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=22087&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=22087&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=22087&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=22087&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=22087&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=22087&r=gnused
