OCI8 Funktionen

Inhaltsverzeichnis

oci_bind_array_by_name — Bindet ein PHP-Array namentlich an ein Oracle-PL/SQL-Array
oci_bind_by_name — Bindet eine PHP-Variable an einen Oracle Platzhalter
oci_cancel — Bricht das Lesen eines Zeigers ab.
oci_close — Schliesst eine Oracle-Verbindung
OCI-Collection->append — Hängt das Element an die Sammlung
OCI-Collection->assign — Weisst einen Wert aus einer anderen existierenden Sammlung einer Sammlung zu
OCI-Collection->assignElem — Weisst einem Element in der Sammlung einen Wert zu
OCI-Collection->free — Gibt die verknüpften Ressources eines Sammelobjekts frei
OCI-Collection->getElem — Gibt den Wert des Element zurück
OCI-Collection->max — Liefert die maximale Anzahl Elemente in einer Sammlung
OCI-Collection->size — Liefert die Größe der Sammlung
OCI-Collection->trim — Stutzt Element am Ende einer Sammlung
oci_commit — Commits outstanding statements
oci_connect — Establishes a connection to the Oracle server
oci_define_by_name — Uses a PHP variable for the define-step during a SELECT
oci_error — Liefert den letzten Fehler
oci_execute — Executes a statement
oci_fetch_all — Holt alle Reihen der Ergebnisdaten in ein Array
oci_fetch_array — Liefert die nächste Zeile der Ergebnisdaten als assoziatives und/oder numerisches Array
oci_fetch_assoc — Liefert die nächste Zeile der Ergebnisdaten als assoziatives Array
oci_fetch_object — Liefert die nächste Zeile der Ergebnisdaten als Objekt
oci_fetch_row — Liefert die nächste Zeile der Ergebnisdaten als numerisches Array
oci_fetch — Holt die nächste Reihe in den Ergebnispuffer
oci_field_is_null — Checks if the field is NULL
oci_field_name — Returns the name of a field from the statement
oci_field_precision — Tell the precision of a field
oci_field_scale — Tell the scale of the field
oci_field_size — Returns field's size
oci_field_type_raw — Tell the raw Oracle data type of the field
oci_field_type — Returns field's data type
oci_free_statement — Gibt alle verknüpften Ressourcen eines Statements oder Zeigers frei.
oci_internal_debug — Enables or disables internal debug output
OCI-Lob->append — Appends data from the large object to another large object
OCI-Lob->close — Closes LOB descriptor
oci_lob_copy — Copies large object
OCI-Lob->eof — Tests for end-of-file on a large object's descriptor
OCI-Lob->erase — Erases a specified portion of the internal LOB data
OCI-Lob->export — Exports LOB's contents to a file
OCI-Lob->flush — Flushes/writes buffer of the LOB to the server
OCI-Lob->free — Frees resources associated with the LOB descriptor
OCI-Lob->getBuffering — Returns current state of buffering for the large object
OCI-Lob->import — Imports file data to the LOB
oci_lob_is_equal — Compares two LOB/FILE locators for equality
OCI-Lob->load — Returns large object's contents
OCI-Lob->read — Reads part of the large object
OCI-Lob->rewind — Moves the internal pointer to the beginning of the large object
OCI-Lob->save — Saves data to the large object
OCI-Lob->saveFile — Alias von oci_lob_import
OCI-Lob->seek — Sets the internal pointer of the large object
OCI-Lob->setBuffering — Changes current state of buffering for the large object
OCI-Lob->size — Returns size of large object
OCI-Lob->tell — Returns current position of internal pointer of large object
OCI-Lob->truncate — Truncates large object
OCI-Lob->write — Writes data to the large object
OCI-Lob->writeTemporary — Writes temporary large object
OCI-Lob->writeToFile — Alias von oci_lob_export
oci_new_collection — Allocates new collection object
oci_new_connect — Establishes a new connection to the Oracle server
oci_new_cursor — Allocates and returns a new cursor (statement handle)
oci_new_descriptor — Initializes a new empty LOB or FILE descriptor
oci_num_fields — Returns the number of result columns in a statement
oci_num_rows — Returns number of rows affected during statement execution
oci_parse — Prepares Oracle statement for execution
oci_password_change — Changes password of Oracle's user
oci_pconnect — Connect to an Oracle database using a persistent connection
oci_result — Returns field's value from the fetched row
oci_rollback — Rolls back outstanding transaction
oci_server_version — Returns server version
oci_set_prefetch — Sets number of rows to be prefetched
oci_statement_type — Returns the type of an OCI statement
ocibindbyname — Alias von oci_bind_by_name
ocicancel — Alias von oci_cancel
ocicloselob — Alias von
ocicollappend — Alias von
ocicollassign — Alias von
ocicollassignelem — Alias von
ocicollgetelem — Alias von
ocicollmax — Alias von
ocicollsize — Alias von
ocicolltrim — Alias von
ocicolumnisnull — Alias von oci_field_is_null
ocicolumnname — Alias von oci_field_name
ocicolumnprecision — Alias von oci_field_precision
ocicolumnscale — Alias von oci_field_scale
ocicolumnsize — Alias von oci_field_size
ocicolumntype — Alias von oci_field_type
ocicolumntyperaw — Alias von oci_field_type_raw
ocicommit — Alias von oci_commit
ocidefinebyname — Alias von oci_define_by_name
ocierror — Alias von oci_error
ociexecute — Alias von oci_execute
ocifetch — Alias von oci_fetch
ocifetchinto — Fetcht die nächste Zeile des Ergebnisses in ein Array (deprecated!)
ocifetchstatement — Alias von oci_fetch_all
ocifreecollection — Alias von
ocifreecursor — Alias von oci_free_statement
ocifreedesc — Alias von
ocifreestatement — Alias von oci_free_statement
ociinternaldebug — Alias von oci_internal_debug
ociloadlob — Alias von
ocilogoff — Alias von oci_close
ocilogon — Alias von oci_connect
ocinewcollection — Alias von oci_new_collection
ocinewcursor — Alias von oci_new_cursor
ocinewdescriptor — Alias von oci_new_descriptor
ocinlogon — Alias von oci_new_connect
ocinumcols — Alias von oci_num_fields
ociparse — Alias von oci_parse
ociplogon — Alias von oci_pconnect
ociresult — Alias von oci_result
ocirollback — Alias von oci_rollback
ocirowcount — Alias von oci_num_rows
ocisavelob — Alias von
ocisavelobfile — Alias von
ociserverversion — Alias von oci_server_version
ocisetprefetch — Alias von oci_set_prefetch
ocistatementtype — Alias von oci_statement_type
ociwritelobtofile — Alias von
ociwritetemporarylob — Alias von

oci_bind_array_by_name

OCI8

Last updated: Fri, 22 Aug 2008

add a note User Contributed Notes
OCI8 Funktionen

alvaro at demogracia dot com
10-Jun-2008 01:24


If you've followed the instructions and you can't even connect to the DB server, welcome to the Oracle hell. Most of the information you'll find is deprecated, incomplete, not for your platform, unnecessary or just plain wrong.



Typically, you won't need at all those complicate setups you'll read about and they'll probably make things harder. I suggest you get Systernal's "Filemon" utility (for Windows, in Unix you may do with strace) and find out what exact config files and DLLs are being tried by php.exe (or httpd.exe if PHP runs as Apache module or...). Pretty often, the issue is that (e.g.) TNSNAMES.ORA does not have the correct line ending or Apache is looking for a DLL that does not even exist in your hard disc; learning that prevents you to waste time adding more and more useless environmental variables.



Goog luck.

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

oci_bind_array_by_name

OCI8

Last updated: Fri, 22 Aug 2008