RAD Studio 10.4.1 is now available! Learn more. 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

Location

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.

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

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

Uses

For the original post please refer to the link below:

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


Reduce development time and get to market faster with RAD Studio, Delphi, or C++Builder. Design. Code. Compile. Deploy. Start Free Trial   Free Delphi Community Edition   Free C++Builder Community Edition   Upgrade Today
Sign up for our daily posts newsletter!

Leave a Reply

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

IN THE ARTICLES