Using Stored Procedures

Before you can create a stored procedure to insert a new customer, follow the steps in the topic Connecting to a Database.

The PersonPB application supports stored procedures to insert new customer records. Stored procedures are available mainly to demonstrate additional Silk Performer Recorder features.
  1. On the Customer OCI dialog box, make sure no stored procedures exist.
  2. Click Create. You can now use the stored procedure to insert a new customer.
  3. Click Cancel.
  4. Enter the new customer data, at least its first and its last name.
  5. Click Insert using SP.
    Note: Since the new customer record is not selected automatically, you have to click Select for the new customer to become visible.
  6. To drop a stored procedure, click Drop.
Parent topic: Working with PersonPB