Site icon Embarcadero RAD Studio, Delphi, & C++Builder Blogs

Easily Learn To Work With Oracle Stored Procedures In Delphi On Windows With This Sample App

Location

You can find the OraclStoredProc sample project at:

Description

The OraclStoredProc sample shows you how to work with Oracle stored procedures.Note: This demo requires Oracle Demo connection definition. See Demo Databases.

How to Use the Sample

  1. Navigate to the location given above and open Ora_StoredProc.dproj.
  2. Press F9 or choose Run > Run.
  3. Click on the Use Connection Definition combo box and select an option.

Files

File in DelphiContains
Ora_StoredProc.dproj
Ora_StoredProc.dpr
The project itself.
fOra_StoredProc.pas
fOra_StoredProc.fmx
The main form.

Implementation

The sample implements the following features.

Create table adapter

[crayon-673fcfcfe570e667471111/]

Assign command

[crayon-673fcfcfe5715193952502/]

Set the DatSTable name

To set the DatSTable name where the rows are fetched, type the following:

[crayon-673fcfcfe5717180806971/]

Set up the SelectCommand property

The SelectCommand property is set up by setting the following properties:

Once the parameters are set up, the sample calls the Prepare method.

[crayon-673fcfcfe5718717230833/]

Fetch rows

[crayon-673fcfcfe571a302058029/]

Uses

For the original post please refer to the link below:

http://docwiki.embarcadero.com/CodeExamples/Sydney/en/FireDAC.OraclStoredProc_Sample

Exit mobile version