Difference between revisions of "Oracle"
From Lazarus wiki
Jump to navigationJump to search (added invalid character fix) |
|||
Line 9: | Line 9: | ||
== OOP access to Oracle == | == OOP access to Oracle == | ||
The SQLDB framework supplied with FPC supports accessing Oracle (using TOracleConnection); see [[Lazarus_Database_Overview#Lazarus_and_Oracle]] | The SQLDB framework supplied with FPC supports accessing Oracle (using TOracleConnection); see [[Lazarus_Database_Overview#Lazarus_and_Oracle]] | ||
+ | |||
+ | {{Note|Lazarus x64 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 == | == Troubleshooting == |
Revision as of 06:50, 28 May 2013
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: Lazarus x64 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