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

How to connect to Oracle DB from Ubuntu Linux.

the future of starts demands massive productivity

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.

 

Do you want to try Embarcadero’s Cross-Platform Development Framework? InterBase is an ultrafast, scalable, embeddable SQL database with commercial grade data security, disaster recovery, and change synchronization. Request a free full trial here.

See What's New in 12.2 Athens See What's New in 12.2 Athens Dev Days of Summer 2-24

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.

IN THE ARTICLES