A SQL call (for example, OSQL3) must be used to pass a SQL
statement to Oracle and to associate the statement with an open cursor. A cursor must already have an associated SQL statement if referenced in any of the following calls: DESCRIBE, NAME, DEFINE, BIND, EXECUTE,
and FETCH.
Action
Do the SQL call, for example, OSQL, to pass the required SQL statement before referencing the cursor.
ORA–01004
default username feature not supported; logon denied
Cause
An attempt was made to use automatic logon on a system not supporting this feature.
Action
Provide the complete username and password to log on to Oracle.
ORA–01005
null password given; logon denied
Cause
An invalid password was given when logging on.
Action
Provide a valid password.
ORA–01006
bind variable does not exist
Cause
A program issued a BIND call for a variable not listed in the associated SQL
statement. Only those variables prefixed by either a colon (:) or ampersand (&) in the SQL statement may be referenced in a BIND call, OBIND or OBINDN.
This error may also be caused by a mismatch between a Precompiler program and the related library, SQLLIB.
Action
Modify the BIND call to reference one of the substitute variables specified in the associated SQL statement.
ORA–01007
variable not in select list
Cause
A reference was made to a variable not listed in the SELECT clause. In OCI, this can occur if the number passed for the position parameter is less than one or greater than the number of variables in the SELECT clause in any of the following calls: DESCRIBE, NAME, or DEFINE. In SQL*Forms or SQL*Report, specifying more variables in an INTO clause than in the SELECT clause also causes this error.
Action
In OCI, specify a position number between 1 and the number of variables in the SELECT clause. In SQL*Forms or SQL*Report, specify an equal number of variables in the SELECT and INTO clauses.
2 – 70
Oracle7 Server Messages
01000–01099: User Program Interface
ORA–01008
not all variables bound
Cause
A SQL statement containing substitution variables was executed without all variables bound. All substitution variables must have a substituted value before the SQL statement is executed.
Action
In OCI, use an OBIND or OBINDN call to substitute the required values.
ORA–01009
missing mandatory parameter
Cause
A host language program call did not pass all required parameters. The syntax and parameter description for each call is shown in the Programmer’s Guide to the Oracle Precompilers.
Action
Check the syntax for the call and enter all required parameters.
ORA–01010
invalid OCI operation
Cause
One of the following:
• You attempted an invalid OCI operation.
• You are using an Oracle client application linked version 7.1, or higher libraries, the environment ORA_ENCRYPT_LOGIN is set to TRUE, and
you attempted to connect to a version 7.0, or lower, Oracle Server.
• You are connected to a version 7.1, or higher, Oracle Server, the initialization parameter DBLINK_ENCRYPT_LOGIN is set to TRUE, and
you attempted to use a database link pointing to a version 7.0, or lower, Oracle Server.
Action
For the above causes:
• Do not use the invalid OCI operation.
• If you do not wish to use encrypted connect passwords in your
distributed database, set ORA_ENCRYPT_LOGIN to FALSE.
If you wish to use encrypted connect passwords, you must upgrade all Oracle Servers to version 7.1, or higher.
• If you do not wish to use encrypted database links in your distributed database, set DBLINK_ENCRYPT_LOGIN to FALSE.
If you wish to use encrypted database links, you must upgrade all Oracle Servers to version 7.1, or higher.
ORA–01011
cannot use Oracle7 compatibility mode with an Oracle Version 6 server Cause
An attempt was made to use Oracle7 compatibility mode when accessing Oracle Version 6.
Action
Do not use Oracle7 compatibility mode when accessing Oracle Version 6.
Oracle7 Server Messages
2 – 71
01000–01099: User Program Interface
ORA–01012
not logged on
Cause
A host language program issued an Oracle call, other than OLON or


 

 

 

 

 

 

 

 

 

 

 

 

   
 
  ORA–01003 no statement parsed Cause A host language program call referenced a cursor with no associated parsed SQL statement...
Pomodliłem się do każdego boga jaki istniał bym był w wstanie wkurzyć tę kobietę do granic możliwości.