The list of questions and answers related to Oracle Server.
A: Just put tnsnames.ora file in the same folder, where Oracle Instant Client is located. No need to do something other, like specifying TNS_Admin or TNS_Names. If you does not need to use TNS aliases, then put empty tnsnames.ora file.
A: AnyDAC cannot initialize OCI in the Unicode mode, that is required for D2009. Most probably, that is due to the old Oracle client version. We will suggest:
A: Using the following "roadmap" you can choose the correct Oracle client and Delphi versions:
A: Generic skeleton for your task may look like:
ADConnection1.StartTransaction; try ADConnection1.ExecSQL('LOCK TABLE ...'); ......... ADConnection1.Commit; except ADConnection1.Rollback; raise; end;
A: Not at this moment. As a workaround you can build PL/SQL wrapping procedures and functions. Using this approach, you can then work with Oracle Advanced Queuing.
What do you think about this topic? Send feedback!