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

ORA-02223: invalid OPTIMAL storage option value

1 Answers  


ORA-30034: Undo tablespace cannot be specified as temporary tablespace

1 Answers  


ORA-00079: variable string not found

1 Answers  


PCC-00103: AT clause is an Oracle extension

1 Answers  


ORA-23356: masterdef recognizes a master which does not recognize the masterdef

1 Answers  






NZE-29003: SSL transport detected mismatched server certificate.

1 Answers  


ORA-16093: dependent archive log destination is not LGWR-enabled

1 Answers  


PCC-02426: Incompatible LOB types

1 Answers  


ORA-27453: %s is an invalid job or program argument name.

1 Answers  


NNL-00213: No entry with specified index number, try "SHOW SYSTEM_QUERIES"

1 Answers  


QSM-02012: a CONNECT BY clause is present

1 Answers  


ORA-06266: NETNTT: bad write length

1 Answers  


Categories