Using Embedded SQL with Oracle – PB Docs 126

Using Embedded SQL with Oracle

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.


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

Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Notify of
Inline Feedbacks
View all comments
Would love your thoughts, please comment.x