PLS-00402: alias required in SELECT list of cursor to avoid
duplicate column names
Answer Posted / chimbu
Remove the same column name in cusor query.
ex:
select a1,a2,a1 from table1;
Here their are two columns named a1.
Remove it and you wont get the error
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
ORA-26028: index string.string initially in unusable state
if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires
IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created
when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly
ORA-26084: direct path context already finished
ORA-26029: index string.string partition string initially in unusable state
ORA-26032: index string.string loading aborted after string keys
IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier
IMP-00064: Definition of LOB was truncated by export
ORA-26030: index string.string had string partitions made unusable due to:
ORA-26094: stream format error: input column overflow
ORA-26079: file "string" is not part of table string.string
ORA-07497: sdpri: cannot create trace file 'string'; errno = string.
ORA-26095: unprocessed stream data exists
IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier