|
- ORA-01403: no data found for Select into - Stack Overflow
I am getting ORA-01403: no data found exception for the following query What are the possibilities of this error? SELECT trim (name) INTO fullname FROM ( SELECT n name FROM directory
- Why do I have ORA-00904 even when the column is present?
ORA-00904-invalid identifier errors are frequently caused by case-sensitivity issues Normally, Oracle tables and columns are not case sensitive and cannot contain punctuation marks and spaces But if you use double quotes to create a quoted identifier, that identifier must always be referenced with double quotes and with the correct case For example: create table bad_design
- ORA-32795: cannot insert into a generated always identity column
One of the columns in your target table (leaves_approval) contains an identity column that was defined as Generated always Identity columns can be created in 2 modes - Generated always, that cannot be assigned and Generated by default that can be assigned
- stored procedures - Oracle Error ORA-06512 - Stack Overflow
oracle-database stored-procedures plsql ora-06512 edited Oct 19, 2011 at 4:32 Ernesto Campohermoso 7,411 1 41 51
- ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
If you had two identical values in the table - abcd twice, say, with the same case - then your ALTER TABLE would throw ORA-02299 despite the NOVALIDATE, as it won't be able to create the unique index to back that up In 11g you could create a virtual column and constrain that, but you have the same problem creating the unique index
- ORA-03150: end-of-file on communication channel for database link
ORA-03150: end-of-file on communication channel for database link Asked 7 years, 6 months ago Modified 2 months ago Viewed 53k times
- import - Why do I get ORA-39001: invalid argument value when I try to . . .
Why do I get ORA-39001: invalid argument value when I try to impdp in Oracle 12c? Asked 9 years, 1 month ago Modified 9 years, 1 month ago Viewed 76k times
- ORA-00932: inconsistent datatypes: expected - got CLOB
Considering that TEST_SCRIPT is a CLOB why when I run this simple query from SQL*PLUS on Oracle, I get the error: ORA-00932: inconsistent datatypes: expected - got CLOB I have been reading a lot
|
|
|