PHP
downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

oci_bind_array_by_name> <Oracle OCI8
Last updated: Fri, 11 Apr 2008

view this page in

Oracle OCI8 Funzioni

Indice dei contenuti



oci_bind_array_by_name> <Oracle OCI8
Last updated: Fri, 11 Apr 2008
 
add a note add a note User Contributed Notes
OCI8
christopher dot jones at oracle dot com
17-Jun-2007 06:25
There are several good books on PHP and Oracle available - search your favorite bookstore.  There is also a free book from Oracle "The Underground PHP and Oracle Manual" that covers the OCI8 extension: http://otn.oracle.com/tech/php/pdf/underground-php-oracle-manual.pdf
(free registration for OTN required, IIRC). Disclaimer: I'm one of its authors.
James VL
28-Feb-2007 07:49
re: Andrei Kubar

I was using Oracle Instant Client on Windows XP, and was getting the

PHP Startup: Unable to load dynamic library 'C:\php\ext\php_oci8.dll' - The specified module could not be found.

error at startup, even though I had done all (most?) of the PHP and Oracle setup routines.

For me it wasn't the lack of mfc*.dll files, but a simple PATH issue: in addition to defining the environment variable TNS_ADMIN, I had to include my instant client directory in my PATH.
darkstar_ae at hotmail dot com
26-Apr-2005 07:39
When fetching associative arrays, use uppercase string indices. It appears the PHP OCI Library is less lenient with the field names returned by Oracle.

e.g.

echo $row['field1']; // This won't return anything.

as opposed to:

echo $row['FIELD1'];
edahnke at consultant dot com
08-Jan-2002 09:01
Here's a little snipet that shows how to insert multiple clob fields. Worked for me.

$dbh = OCILogon($dst_user_name, $dst_password, $dst_db_name);

for($i = 0; $i < $src_rec_cnt; $i++) {
    $query = "insert into bid (id,time,resume,experience,comments) values ('$id[$i]','$time[$i]',empty_clob(),empty_clob(),empty_clob()) returning  resume,experience,comments into :resume,:experience,:comments";

    $stmt = OCIParse($dbh, $query);

    $clob1 = OCINewDescriptor($dbh, OCI_D_LOB);
    $clob2 = OCINewDescriptor($dbh, OCI_D_LOB);
    $clob3 = OCINewDescriptor($dbh, OCI_D_LOB);
   
    OCIBindByName ($stmt, ":resume", &$clob1, -1, OCI_B_CLOB);
    OCIBindByName ($stmt, ":experience", &$clob2, -1, OCI_B_CLOB);
    OCIBindByName ($stmt, ":comments", &$clob3, -1, OCI_B_CLOB);

    OCIExecute($stmt, OCI_DEFAULT);
   
    @$clob1->save ($resume[$i]);
    @$clob2->save ($experience[$i]);
    @$clob3->save ($comments[$i]);
   
    OCICommit($dbh);
doug at redhive dot com
19-Jul-2001 11:38
if you feel like you have too many oracle statements clouding up your php, i came up with a function to open a connection (if necessary), parse your sql statement, and return the executed query.  after you call the function, you can do whatever needs to be done.  makes like so much simpler: (do whatever you want with the errors)

function execute_query($query, &$connected) {
    global $ORACLE_USER, $ORACLE_PASS, $ORACLE_SID;

    if(!$connected) {
        $connected = @OCIPLogon($ORACLE_USER, $ORACLE_PASS,  $ORACLE_SID);

        if($error = OCIError()) {
            die("<font color=red>ERROR!! Couldn't connect to server!</font>");
        }
    }

    $stmt = @OCIParse($connected, $query);
    if($error = OCIError($cn))    {
        die("<font color=red>ERROR!! Statement syntax error!</font>");
    }

    @OCIExecute($stmt);
    if($error = OCIError($stmt)) {
        die("<font color=red>ERROR!! Could not execute statement!</font>");
    }

    return $stmt;
}
jasendorf at lcounty dot com
24-May-2001 12:48
VERY IMPORTANT!  OCIPLogon only keeps a persistent connection if you are running PHP as a module.  This is particularly important to Windows users who are used to running PHP as a CGI.
junk at netburp dot com
19-Oct-2000 11:39
Here's a clue about rowid.

Don't forget about the oracle functions:

"rowidtochar" and "chartorowid"

"select rowidtochar(rowid) as FOO from table ...."

When you want to pass the rowid in a form or link, that's
the only way to go.
add a note add a note

oci_bind_array_by_name> <Oracle OCI8
Last updated: Fri, 11 Apr 2008
 
 
show source | credits | sitemap | contact | advertising | mirror sites