Using Transaction objects to call stored procedures  Step 2: declare the stored procedure as an external function

Chapter 12: Using Transaction Objects

Step 1: define the standard class user object

StepsTo define the standard class user object:

  1. Start PowerBuilder.

  2. Connect to a database that supports stored procedures.

    The rest of this procedure assumes you are connected to an Oracle database that contains remote stored procedures on the database server.

    For instructions on connecting to an Oracle database in PowerBuilder and using Oracle stored procedures, see Connecting to Your Database.

  3. Click the New button in the PowerBar, or select File>New from the menu bar.

    The New dialog box displays.

  4. On the Object tab, select the Standard Class icon and click OK to define a new standard class user object.

    The Select Standard Class Type dialog box displays:

    The Select Standard Class Type dialog box displays the title Types and a scrollable list of the standard types available. In the example, the type transaction is highlighted. To the right are three buttons, OK, Cancel, and Help.

  5. Select transaction as the built-in system type that you want your user object to inherit from, and click OK.

    The User Object painter workspace displays so that you can assign properties (instance variables) and functions to your user object:




Copyright © 2011. Sybase Inc. All rights reserved. Step 2: declare the stored procedure as an external function

View this document as PDF