A question about PL/SQL

From: Raymond Ho-Yin Chow <chow3_at_uwindsor.ca>
Date: 1995/04/12
Message-ID: <D6y282.M9I_at_news.uwindsor.ca>#1/1


It seems some PL/SQL programs can only run once on a sqlplus seesion If I run the following program twice, I will get the message

DECLARE
*
Error at line 1
ORA-03113:end-of-file on communication channel

The system will then disconnect me from oracle. Can any one tell me what the problem is? Thanks  

/* the program does nothing */
DECLARE

	TYPE testtype IS TABLE OF INTEGER
		INDEX BY BINARY_INTEGER;
	X  testtype;
	FUNCTION HO (A testtype   ) RETURN testtype IS
	BEGIN
		RETURN A;
	END HO;
BEGIN
	X(1):=10;
	X(2):=20;
	X:=HO(X);

END;         
-- 
----------------------------------------------------------------------------

|Raymond Ho-Yin Chow | chow3_at_server.uwindsor.ca |
|Undergraduate Student| University of Windsor |
----------------------------------------------------------------------------
Received on Wed Apr 12 1995 - 00:00:00 CEST

Original text of this message