Have an amazing solution built in RAD Studio? Let us know. Looking for discounts? Visit our Special Offers page!
CodeDatabaseDelphiRAD Studio

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


You can find the OraclStoredProc sample project at:

  • Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to:
    • Object Pascal\Database\FireDAC\Samples\DApt Layer\Oracl_StoredProc
  • Subversion Repository:
    • You can find Delphi code samples in GitHub Repositories. Search by name into the samples repositories according to your RAD Studio version.


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.


File in DelphiContains
The project itself.
The main form.


The sample implements the following features.

Create table adapter

Assign command

Set the DatSTable name

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

Set up the SelectCommand property

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

  • BaseObjectName to set the package name.
  • CommandText to set the procedure name.
  • Command Kind to set the kind of content of the CommandText property. It is set to stored procedure with cursor.

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

Fetch rows


For the original post please refer to the link below:


Reduce development time and get to market faster with RAD Studio, Delphi, or C++Builder.
Design. Code. Compile. Deploy.
Start Free Trial   Upgrade Today

   Free Delphi Community Edition   Free C++Builder Community Edition

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.