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-09365: Windows 3.1 Two-Task driver unable to destroy hidden window

1 Answers  


ORA-24960: the attribute string is greater than the maximum allowable length of number

1 Answers  


ORA-01576: The instance string is not enabled

1 Answers  


NNF-01008: XDS attribute syntax string incorrect for Oracle Names syntax string

1 Answers  


ORA-27479: Cannot string "string.string" because other objects depend on it

1 Answers  






NNO-00623: setting auto-refresh retry interval to number seconds

1 Answers  


ORA-06802: TLI Driver: could not open the /etc/netware/yellowpages file

1 Answers  


ORA-01171: datafile string going offline due to error advancing checkpoint

1 Answers  


NCR-04005: NCRR: Invalid procedure handle

1 Answers  


NZE-28750: unknown error

1 Answers  


ORA-36268: (XSCGMDLAGG01) 'string' is not a valid dimension value.

1 Answers  


DRG-50905: invalid score threshold string

1 Answers  


Categories