RAD Studio 10.4.1 is now available! Learn more. Looking for discounts? Visit our Special Offers page!
Delphi

How to connect to Oracle DB from Ubuntu Linux.

Author: h.mohri

 

At this point, Instant Client configuration is complete.

Finally, “./PAServer-19.0/paserver” is started up and ready.


 

 

[Create a new project.]

In Delphi IDE side, create a new project. Web Server Application, check Linux.

I chose “stand-alone console application” this time.

Place some components on TWebModule1.

TFDConnection, TFDPhysOracleDriverLink, TFDQuery, TFDStanStorageJSONLink

Return the contents acquired by FDQuery1 with JSON. Write the code.

There is a simple table and some records on DB side.

 

When executing debugging, the following option is mandatory.

“/usr/bin/xterm -e “%debuggee%””

 

 

 

[In case of failure.]

Failure Review the environment on the Linux side.

 

[In case of success.]

 

The content saved by JSON of FDQuery1 is displayed.

 

 

 

 

 


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

Related posts
DatabaseInterBaseRAD Studio

Learn How To Connecing To Local InterBase Instances In This Video

InterBaseNewsRAD Studio

Migrating from BDE/Paradox to InterBase

C++DatabaseDelphi

Quick Introduction To FireDAC And Its Features For Building Robust Delphi/C++ Builder Database Applications.

C++CodeDelphi

Learn A Quick Way To Connect To A MySQL Database With The Delphi FireDAC Access Sample App

Leave a Reply

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

IN THE ARTICLES