OraFAQ Forum: SQL & PL/SQL » Problem related to ref cursor and collections

Home » SQL & PL/SQL » SQL & PL/SQL » Problem related to ref cursor and collections

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Mon, 15 April 2002 11:00

ranjan
Messages: 20
Registered: August 1999

Junior Member

Hi,
I want to build a ref cursor from a nested tabel.

My code some what looks like:

PROCEDURE display_proj_emp
IS
TYPE rc_c1 IS REF CURSOR;
l_c1 rc_c1;

BEGIN

OPEN l_c1 FOR
'SELECT * FROM TABLE(CAST(Nested Table variable AS nested table type)) ';

END LOOP;
CLOSE l_c1;
END;
But when I execute this this gives some internal error.
Any suggestion how to build ref cursor from oracle nested collection types.

Report message to a moderator

Mon, 15 April 2002 11:48

Cindy
Messages: 88
Registered: November 1999

Member

http://asktom.oracle.com/pls/ask/f?p=4950:8:67220::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:934320224769,%7Bnested%7D%20and%20%7Btable%7D%20and%20%7Bref%7D%20and%20%7Bcursor%7D

http://asktom.oracle.com/pls/ask/f?p=4950:8:67220::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1197506802041,%7Bnested%7D%20and%20%7Btable%7D%20and%20%7Bref%7D%20and%20%7Bcursor%7D

Report message to a moderator

Mon, 15 April 2002 14:45

ranjan
Messages: 20
Registered: August 1999

Junior Member

I am getting the following error:
1 select * from dual
2 where
3 exists ( select *
4 from THE ( select cast( danka_pkg.in_list( '1, 3, 5, 7, 99' ) as mytab ) from
5* dual ) )
6 /
select * from dual
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

Please suggest.

Thanks

Report message to a moderator

Tue, 16 April 2002 07:10

Cindy
Messages: 88
Registered: November 1999

Member

I don't know if any of these information will help, but you can take a look at it.

ORA-03113 end-of-file on communication channel
Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the SQL*Net, two task, software. This message could occur if the shadow two-task process associated with a SQL*Net connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.

Action: If this message occurs during a connection attempt, check the setup files for the appropriate SQL*Net driver and confirm SQL*Net software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support.

http://www.orafans.com/ubb/Forum6/HTML/000815.html

http://www.orafans.com/ubb/Forum6/HTML/002634.html

http://www.orafaq.net/cgi-bin/search/query?q=ORA--03113&mode=all

http://www.oracle-error.com/ora-03113.htm

http://www.jlcomp.demon.co.uk/faq/ORA-3113.html

Report message to a moderator

Previous Topic:	Unable to parse a PL/SQL Block
Next Topic:	Successful or not...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 20:10:52 CDT 2024