Using Embedded SQL with Oracle
Contents
- Oracle Name
qualification - Oracle SQL
functions - Oracle
Transaction management statements - Oracle Using
CONNECT, DISCONNECT, COMMIT, and ROLLBACK - Oracle
Performance and locking - Oracle
Non-cursor statements - Oracle
DELETE, INSERT, and UPDATE - Oracle
SELECT - Oracle
Cursor statements - Oracle
Retrieval - Oracle
Update - Oracle
Cursor support summary - Oracle
Database stored procedures - Supported features when using
Oracle stored procedures - Using
DECLARE, EXECUTE, FETCH, and CLOSE with Oracle stored procedures - Oracle
DECLARE and EXECUTE - Oracle
FETCH - Oracle
CLOSE
About this chapter
When you create scripts for a PowerBuilder application, you can use
embedded SQL statements in the script to perform operations on the database.
The features supported when you use embedded SQL depend on the DBMS to which
your application connects.
Overview
When your PowerBuilder application connects to an Oracle database, you
can use embedded SQL in your scripts.
If you are using these interfaces to connect to an Oracle database,
you can embed the following types of SQL statements in scripts and
user-defined functions:
-
Transaction management statements
-
Non-cursor statements
-
Cursor statements
-
Database stored procedures
When you use Oracle database interfaces, PowerBuilder supports SQL
CREATE TYPE and CREATE TABLE statements for Oracle user-defined types
(objects) in the ISQL view of the Database painter. It correctly handles SQL
SELECT, INSERT, UPDATE, and DELETE statements for user-defined types in the
Database and DataWindow painters.
Oracle Call Interface (OCI)
The Oracle database interfaces use the Oracle Call Interface (OCI) to
interact with the database.
When you use embedded SQL, PowerBuilder makes the required calls to
the OCI. Therefore, you do not need to know anything about the OCI to use
embedded SQL in PowerBuilder.
See also
Oracle Transaction
management statements