Transcript Using PowerBuilder to develop applications for Oracle

Bruce Armstrong
TeamSybase
[email protected]
Connection Options
Native
ADO.Net
OLEDB
ODBC
JDBC
Oracle Instant Client
Database Access Methods
DataWindow
RPCFunc Stored
Procedure Call
Embedded Stored
Procedure Call
PL/SQL
Stored
Procedure
Native
Stored
Procedure
(Java, .Net)
Embedded SQL
Statement
DBHandle DLL
Call
Table
DataWindow Demos

Select with
○ Stored function
○ Package function
○ Inline view
○ Constrained REF cursor
○ Unconstrained REF cursor
○ User defined data type
Update through stored procedures
 OLE database blob columns

List Package Subprograms

Make sure the List
Package Subprograms
options is selected for
the database profile
Edit Stored Procedure Options

If you want to modify the source, right
click on the column specification
RPCFunc Call Demos
String arguments
 Number arguments
 Date arguments
 String array arguments
 Number array arguments
 Blob arguments

Java Stored Procedure Demo
.Net Stored Procedure Demo
Embedded SQL Demos
Stored function
 Named notation
 Multiple Cursors

Other Demos
DBHandle DLL call
 Invalid Objects
 Synonyms
 Sequences
 Roles

• Failover Support
• Password Expiration
• Async Calls
• DBMS_ALERT
• DBMS_PIPE
Password Expiration
During Grace Period
After Password Expires
Failover Support

Prior to 11.0
DBParm = “SvrFailover='Yes',FoDialog='Yes‘”

11.0 and later
 DBParm =
“HANotification='Yes',SvrFailover='Yes‘”
 Code dbnotification event on custom
transaction object
Performance Tips
Update those statistics (pre 10g)
 CURSOR_SHARING = SIMILAR (pre
11g)

PowerBuilder 11.5/Oracle 11g
New “ORA” (11g) driver
 Client Access through Proxy

 Connect As option is now editable (not
limited to Normal, SYSDBA and SYSOPER)
OCI Connection and Session Pooling
 Implicit Fetching of ROWID
 Client Cache support
 AppDriverName parameter
 XML Data Type support

Performance Tips
Shared SQL
 Statistics
 Function based indexes

Questions