Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-03113 using multiset

450441Dec 4 2008 — edited Dec 4 2008
This is odd. Anybody seen this before? I ran into it trying the SQL query from http://www.oracle-developer.net/display.php?id=412
SQL> create type number_ntt AS TABLE OF NUMBER;
Type Created.

SQL> select * from v$version
  2  /

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE    9.2.0.3.0       Production
TNS for 32-bit Windows: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production

SQL> select *
  2  from     table(CAST (MULTISET (SELECT     ROWNUM
  3                              FROM DUAL
  4                            CONNECT BY ROWNUM < 5) AS number_ntt)) nt
  5  /
select *
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
This post has been answered by Solomon Yakobson on Dec 4 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 1 2009
Added on Dec 4 2008
4 comments
408 views