Strange error during select: "Need Oracle 9 Call Interface"

Moehre · Post by **Moehre** » Wed 07 Jul 2010 15:03

Dear sirs!

I have written a tool using UniDAC 3.0.0.5 / Delphi 2009 for easy sql queries. This tool is working fine against oracle 10g downto oracle 8i databases.

Now I am writing an intraweb app using UniDAC too. I can't see any difference in using the UniDAC components as used in my sql tool.

Connecting to the oracle 8i database is no problem, but the first time when selecting data from a table I get the message "Need Oracle 9 Call Interface". The same sql select in my tool works fine ?!

Are there any properties in UniDAC Database, Provider oder Query components which could lead to this error?

Many thanks in advance!

Greetz
Detlev

bork · Post by **bork** » Wed 07 Jul 2010 15:46

Hello

You can get the "Need Oracle 9 Call Interface" message if you want to use scrollable cursors (set the Options.ScrollableCursor to True). You will get this message in a standard VCL application and in a IntraWeb application if you try to use scrollable cursors.

Moehre · Post by **Moehre** » Wed 07 Jul 2010 16:05

Thank you very much for this info; I will check it out asap!