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
END;
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;
-- ----------------------------------------------------------------------------Received on Wed Apr 12 1995 - 00:00:00 CEST
|Raymond Ho-Yin Chow | chow3_at_server.uwindsor.ca |
|Undergraduate Student| University of Windsor |
----------------------------------------------------------------------------