 |
|
ss
Oracle Tips by Burleson |
Abstract
OCI stands for “Oracle Call Interface”. The OCI8
module introduced in this chapter is from PHP5. PHP4 supported both
the OCI8 module and an old OCI module used to connect to Oracle7 and
earlier versions. PHP 5 no longer supports the old OCI calls that
originated from version 6 of Oracle RDBMS. This
chapter describes the OCI8 module in detail and consists of the
following sections:
-
Connecting to Oracle - This section describes
various methods for establishing database connections.
-
Handling Errors - This section presents examples
for handling errors by using the oci_error function.
-
Executing SQL - This section reveals the stages
of SQL execution and the description and use of the oci_execute() function.
-
Binding and Defining Variables - This section
describes placeholders and how to “relate” them to script variables.
It shows how to execute PL/SQL procedures and how to bind values to
parameters.
-
Auxiliary OCI8 Functions - This section displays
the results of a query as a HTML table in example form.
-
Oracle Cursors - This section shows how to bind
variables to cursors.
-
Large Objects - This section reveals what large
objects are used for, and how to load large documents into a database.
-
Get Method - This section describes combining the
GET method with PL/SQL, and how to invoke a PHP script with parameters
encoded in the URL.
In many ways, this chapter is central for this
book as it describes in great detail the most basic method that can be
used to establish a communication between an Oracle database and a PHP
script.
See
code depot for complete scripts
The above book excerpt is from:
Easy Oracle
PHP
Create Dynamic Web Pages with Oracle Data
ISBN
0-9761573-0-6
Mladen Gogala
http://www.rampant-books.com/book_2005_2_php_oracle.htm
|
