Oracle

Introduction to Oracle server interface

The oracle server interface exists of one unit, oraoci, which is a straight translation of the oracle interface header files.

There are 2 example programs:

• oraclew contains some utility routines for the oracle interface, for easier management of result sets. Needs the classes unit from the FCL.
• test01 a simple test program to demonstrate the interface.

OOP access to Oracle

The SQLDB framework supplied with FPC supports accessing Oracle (using TOracleConnection); see Lazarus_Database_Overview#Lazarus_and_Oracle

  Note: Released Lazarus x64 versions on Windows does not include an Oracle connector. If you enable it and test succesfully, please submit a patch with the changes so it can be included

Troubleshooting

ORA-00911 : invalid character

If you see this error message, you might want to try

• removing a trailing semicolon - ; - if you have it in a SELECT statement
• adding a trailing semicolon (e.g. in CALL or EXECUTE statements)

See this thread which applies to .Net but may apply to SQLDB as well: [1]

Go back to Packages List