| This statement can only be used with DYNAMIC=ANSI | |
| Cause: | One of the following statements was used without specifying DYNAMIC=ANSI:
o EXEC SQL ALLOCATE/DEALLOCATE/GET/SET DESCRIPTOR o EXEC SQL DESCRIBE OUTPUT/INPUT ... USING ... <descriptor name> o EXEC SQL EXECUTE ... INTO ... o EXEC SQL EXECUTE ... USING... <descriptor name> o EXEC SQL OPEN ... INTO ... o EXEC SQL OPEN ... USING... <descriptor name> o SCROLL in DECLARE CURSOR o EXEC SQL FETCH <orientation> ... where <orientation> is NEXT, PRIOR, FIRST, LAST, ABSOLUTE, or RELATIVE |
| Action: | Specify DYNAMIC=ANSI or remove statement(s) like those above. |
| PCB-00701 | |
Custom Search
|
| More Oracle errors | |
| ORA-41252 | Failed to switch to new session in SSCR |
| ORA-14308 | partition bound element must be one of: string, datetime or interval literal, number, or NULL |
| ORA-19801 | initialization parameter DB_RECOVERY_FILE_DEST is not set |
| ORA-15233 | cannot advance diskgroup compatibility due to [string] |
| LPX-00225 | end-element tag "~1S" does not match start-element tag "~2S" |
| ORA-24060 | cannot convert QUEUE_TABLE, string already is compatible with release string |
| OCI-30115 | error when processing an environment variable |
| RMAN-06216 | WARNING: db_unique_name mismatch - string objects could not be updated |
| ORA-56713 | Insufficient Resource Manager privileges |
| ORA-12350 | database link being dropped is still mounted |
| ORA-13753 | "SQL Tuning Set" "string" already exists for user "string". |
| ORA-23401 | materialized view "string"."string" does not exist |
| ORA-19291 | XPST0081 - specified QName cannot be expanded into a namespace URI |
| ORA-01673 | data file string has not been identified |
| ORA-09914 | Unable to open the ORACLE password file. |
| ORA-00104 | deadlock detected; all public servers blocked waiting for resources |
| DIA-48192 | OS command to move a file failed |
| TNS-00537 | Index into protocol adapter table is out of legal range |
| ORA-19622 | archived log thread string sequence string not restored due to string |
| ORA-38853 | cannot mark instance string (redo thread string) as disabled |
| TOP 20 Oracle errors | |
| ORA-12504 | TNS:listener was not given the SERVICE_NAME in CONNECT_DATA |
| RMAN-20079 | full resync from primary database is not done |
| ORA-14411 | The DDL cannot be run concurrently with other DDLs |
| ORA-14760 | ADD PARTITION is not permitted on Interval partitioned objects |
| ORA-10877 | error signaled in parallel recovery slave string |
| ORA-32701 | Hang detected |
| ORA-00838 | Specified value of MEMORY_TARGET is too small, needs to be at least stringM |
| ORA-16665 | timeout waiting for the result from a database |
| ORA-16957 | SQL Analyze time limit interrupt |
| ORA-16664 | unable to receive the result from a database |
| RMAN-08132 | WARNING: cannot update recovery area reclaimable file list |
| ORA-00000 | normal, successful completion |
| ORA-16766 | Redo Apply is stopped |
| ORA-00837 | Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET |
| RMAN-08137 | WARNING: archived log not deleted as it is still needed |
| DIA-48122 | error with opening the ADR block file [string] [string] |
| ORA-47988 | password should contain at least one numeric and one alphabetic character |
| IMP-00057 | Warning: Dump file may not contain data of all partitions of this table |
| ORA-00001 | unique constraint (string.string) violated |
| ORA-55508 | Invalid input to Flashback Transaction Backout |
| Your own TOP 20 Oracle errors | |
| PCB-00700 | This statement can only be used with DYNAMIC=ANSI |