ID: 22086 Updated by: [EMAIL PROTECTED] Reported By: gnitesh at yahoo dot com -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Red Hat Linux 7.3 PHP Version: 5CVS-2003-02-06 (dev) New Comment:
if you still have that problem, plz send me a short -self contained- php script that shows your problem. i will look into it then. (sidenot i don't actually think that the oci extension supports this kind of anon sql-block - you will have success if you move the block into a store-proc) Previous Comments: ------------------------------------------------------------------------ [2003-02-08 05:38:02] gnitesh at yahoo dot com Thanx for the support. Agreed upon the missing ';' but it isn't really so in the actual case. The problem is something else. Oracle doesn't like the sytanx of my query because I don't have a declare statement for :RID1 but Oracle finds it perfectly alright if I use only 1 query and not more than one query as is the case here. Maybe it's handled internally within PHP when I call OCIBindByName in case of a single and not in case of multiple queries. That's just what I was inquisitive about. Why is it that I don't see an error when I have a single query with variables and OCIBindByName works ok but if I have more than 1 query, even before I reach the stage of calling OCIBindByName Oracle returns me an error. ------------------------------------------------------------------------ [2003-02-06 07:44:13] [EMAIL PROTECTED] Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.php.net/manual/ and the instructions on how to report a bug at http://bugs.php.net/how-to-report.php You forgot to add the semicolon `;' at the end of the second statement. Moreover - I doubt you can run this very thing he way you intended. Try the PL/SQL in SQL *PLUS before trying to run it from PHP. Conclusion - it is Oracle's error message due your bad PLSQL design. Closed as Bogus ------------------------------------------------------------------------ [2003-02-06 02:15:39] gnitesh at yahoo dot com 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 this bug report at http://bugs.php.net/?id=22086&edit=1
