1 / 18

Using PowerBuilder to develop applications for Oracle

Using PowerBuilder to develop applications for Oracle. Bruce Armstrong TeamSybase bruce.armstrong@teamsybase.com. Connection Options. Oracle Instant Client. Database Access Methods. Native Stored Procedure (Java, .Net ). PL/SQL Stored Procedure. Table. DataWindow Demos. Select with

terrene
Download Presentation

Using PowerBuilder to develop applications for Oracle

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using PowerBuilder to develop applications for Oracle Bruce Armstrong TeamSybase bruce.armstrong@teamsybase.com

  2. Connection Options

  3. Oracle Instant Client

  4. Database Access Methods Native Stored Procedure (Java, .Net) PL/SQL Stored Procedure Table

  5. 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

  6. List Package Subprograms • Make sure the List Package Subprograms options is selected for the database profile

  7. Edit Stored Procedure Options • If you want to modify the source, right click on the column specification

  8. RPCFunc Call Demos • String arguments • Number arguments • Date arguments • String array arguments • Number array arguments • Blob arguments

  9. Java Stored Procedure Demo

  10. .Net Stored Procedure Demo

  11. Embedded SQL Demos • Stored function • Named notation • Multiple Cursors

  12. Other Demos • DBHandle DLL call • Invalid Objects • Synonyms • Sequences • Roles • Failover Support • Password Expiration • Async Calls • DBMS_ALERT • DBMS_PIPE

  13. Password Expiration During Grace Period After Password Expires

  14. 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

  15. Performance Tips • Update those statistics (pre 10g) • CURSOR_SHARING = SIMILAR (pre 11g)

  16. 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

  17. Performance Tips • Shared SQL • Statistics • Function based indexes

  18. Questions

More Related