Recent content by support

The HTML manuals are available on the "Oracle Online Generic Documentation CD-ROM". If you do not have this CD-ROM, you can either purchase it from the Oracle Store (USD 9.95), or you can copy them from the Oracle Documentation site at: http://docs.oracle.com In that case you will need some...

This seems like a connection problem. Each SQL Window and Test Window uses its own session, and therefore needs to connect when executed for the first time. You should check this file: %OracleHome%\Network\Admin\sqlnet.ora If it contains this line: SQLNET.AUTHENTICATION_SERVICES=(NTS) Change...

PLS-00801 is by definition an Oracle Server bug. In situations where a compilation works correctly in SQL*Plus, the problem is most likely related to debug information. To work around this, you can disable the debugger preference

Some objects and privileges will only be visible if you have select privileges on the DBA views (e.g. dbs_objects, dba_tab_privs, and so on), and if you have enabled the "Use DBA views if available" preference (Tools > Preferences > Options tab page).

Another user's package bodies will only be visible if you have select privileges on the sys.dba_objects and sys.dba_source views. The "Use DBA views if available" preference (Tools > Preferences > Options tab page) also needs to be enabled to make use of these views. To debug another user's...

If you are using multiple Oracle Homes, it is most likely that PL/SQL Developer is using a different Oracle Home than SQL*Plus. By default, PL/SQL Developer will use the Primary Oracle Home (the one that is listed first in the PATH environment variable. There are 3 ways to resolve this: Start...

This is a known Oracle Server bug (bug# 2276832). For if-then-else statements the Oracle Debug API sometimes reports incorrect execution line numbers. The actual execution is okay though, but it is confusing.

The Test Window does not directly support collection data types as bind variables. For PL/SQL tables you need to pass a local variable of the same type as used in the program unit. For example, the dbms_output.get_lines procedure returns lines in a PL/SQL Table of strings (type...

If you want to view or modify variable values during debugging, the program unit must be compiled with debug information. There are 2 ways to accomplish this: Enable the Debugger preference "Add debug information when compiling" (Tools > Preferences > Debugger tab page). Now you don't have to...

Version 3.3.1 for Delphi 5 available We have released a Delphi 5 version of Direct Oracle Access 3.3.1. The registered and trial version can now be downloaded from our web site. There are no compatibility issues when upgrading your Direct Oracle Access applications, unless you are using the...

All applications that need to access an Oracle database require SQL*Net or Net8. When you try to connect to the database, the TOracleSession tries to determine the SQL*Net or Net8 configuration. If it is not installed, or if it is not properly installed, the error message you mentioned will...

The ORA-01000 error is a very common problem. Every TOracleQuery, TOracleDataSet and TOraclePackage component linked to the same TOracleSession takes up one or more cursors from this session. The OPEN_CURSORS limit is a limit per session, not a transaction limit or system wide limit. The...

String variables in Direct Oracle Access are treated as VARCHAR2 variables on the Oracle Server. If you compare a CHAR column with a VARCHAR2 variable, trailing spaces are significant. Use a Char variable in the TOracleQuery or TOracleDataSet for this where clause to fix the problem. You should...

This problem is most likely caused by Update Pack incompatibility in Delphi 4. Direct Oracle Access for Delphi 4 requires that you have at least Update Pack 2 installed, which is available on the Borland web site: http://www.borland.com/devsupport/delphi/downloads

Both Oracle8 8.0.4 and 8.0.5 have had problems with the dbms_alert package. There was a timing bug that could cause these kinds of problems. For 8.0.4 you need to upgrade to at least 8.0.4.3.2, and for 8.0.5 you need to upgrade to 8.0.5.1.1.