Difference between revisions of "Oracle"
From Lazarus wiki
Jump to navigationJump to searchLine 10: | Line 10: | ||
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}} | + | {{Note|Lazarus x64 1.0.8 and older 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:51, 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 1.0.8 and older 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