ORA-02345: cannot create a view with column based on CURSOR
operator



ORA-02345: cannot create a view with column based on CURSOR operator..

Answer / guest

Cause: A CURSOR operator was used as one of the SELECT
elements in the subquery of a CREATE VIEW or CREATE TABLE
... AS SELECT statement.

Action: Remove the CURSOR operator and replace it with the
CAST operator.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCC-01016: "N" character literals not supported in embedded PL/SQL

1 Answers  


ORA-04067: not executed, string does not exist

1 Answers  


ORA-13757: "SQL Tuning Set" "string" is active.

1 Answers  


ORA-32609: missing REFERENCE keyword in MODEL clause

1 Answers  


LPX-00322: A doc referred by XSLT stylesheet could not be opened : ~s

1 Answers  






ORA-30770: Cannot specify storage options for fixed size opaque type

1 Answers  


ORA-16502: the Data Guard broker operation succeeded with warnings

1 Answers  


ORA-06928: CMX: wrong ORACLE_SID

1 Answers  


ORA-30112: multiple values not allowed for parameter 'string'

1 Answers  


QSM-02131: agg(expr) requires correspondng SUM(expr) function

1 Answers  


ORA-34722: (NLSCHARSET05) CAUTION: Character data loss in character set conversion from string to string

1 Answers  


ORA-24372: invalid object for describe

2 Answers  


Categories