Difference between revisions of "Oracle"
From Free Pascal wiki
Jump to navigationJump to searchm |
(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]] | ||
+ | |||
+ | == 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: [http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/58a27505-a3fb-4cb1-9063-3946b3f26acd] | ||
Go back to [[Package_List|Packages List]] | Go back to [[Package_List|Packages List]] | ||
[[Category:FPC]] | [[Category:FPC]] | ||
[[Category:Databases]] | [[Category:Databases]] |
Revision as of 19:04, 3 December 2012
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
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