When I try to pass an array of numbers to a stored procedure, the stored procedure is not able to get the array contents. Array.count = 0 in the stored procedure! The stored procedure is pretty simple. It just has to insert the parameters into a table. code looks like : TYPE arr_parmid IS TABLE OF testtable.UNID%TYPE INDEX BY BINARY_IN...
I'm using php 5.2 with oracle 11.1. This code: $query = oci_parse($conn, "SELECT * FROM COMMENTS WHERE PINID=$pinID and COMMENTID=$commentID"); results in this error: <b>Warning</b>: oci_execute() [<a href='function.oci-execute'>function.oci-execute</a>]: ORA-00904: "COMMENTS": invalid identifier in <b>C:\IODwww\hello.php...
Can anybody point me to a good OCI quick tutorial? I took a tour of official Oracle documentation, but it is really huge (and I know OCI deserves every line of it, anyway). Since I'm starting off with OCI I would like to have something more brief to play around with initially, and by which I can figure out how this interface works. A...
The company I work for currently uses some basic functions to abstract the OCI libraries as a means for DB connectivity. We're considering switching to PHP's PDO object, but from some quick searches, it looks like the Oracle driver is a bit less mature than the other PDO drivers. I would appreciate some pro/cons for PDO/Oracle from any...
Does anybody have any experience going from ODP.net to devArt's dotConnect for Oracle? Some initial testing is showing Direct Connect in 64bit dotConnect running 30% slower at times than our original ODP.net/OCI 32 bit solution. Trying to determine if that's normal or if something may be wrong in my testing approach. Thanks! ...
I'm using OTT to pass and load an Object Type from a C++ external procedure. The problem I have is that I don't know how to somehow mark the object for deallocation once extproc has done marshalling it. The object remains in extproc's memory forever making it grow in memory consumtion. Here's part of the code: void decodeFromBuffer(OCIE...
Hi all, Can you please help me understand something in this function? From the documentation, it says if I use function oci_bind_by_name and don't define the type, it will use the default SQLT_CHR. My question is how Oracle handles this variable. Imagine I do this for a select in a table which have an index in a field of type NUMBER. W...
Curious as to whether or not you can prepare a statement, bind it, and then preview the generated SQL as followed (the oci_preview_sql function is a place holder): // Glorious declaration of a non-specific query $statment = oci_parse($handle, "SELECT x FROM y WHERE variable = :value"); // Bind up some variables oci_bind_by_name($statem...
Catchable fatal error: Object of class OCI-Collection could not be converted to string in E:\php\htdocs\PHPRPC\func.php on line 318 The code: $sql='BEGIN NCCM_INTERFACE_HISDETAIL(:orgcode,:inhiscode,:inputer,:items); END;'; $conn=oci_connect('chis','chis123','ORCL','UTF8'); $stmt = oci_parse($conn, $sql); $collection = oci_new_collecti...