PL/SQL run from SQL*Plus
From: <mcgrathm_at_vax1.tcd.ie>
Date: Fri, 5 Mar 1993 09:31:38 GMT
Message-ID: <1993Mar5.093138.1_at_vax1.tcd.ie>
END LOOP;
END;
/ Received on Fri Mar 05 1993 - 10:31:38 CET
Date: Fri, 5 Mar 1993 09:31:38 GMT
Message-ID: <1993Mar5.093138.1_at_vax1.tcd.ie>
Hi Folks,
I wish to run a PL/SQL script from SQL*PLUS. However
I am getting error messages such as:-
This occurs for each of the PL/SQL commands. I have appended the script below.
My Questions are (1) Can PL/SQL be run as a script from SQL*PLUS ?
(2) If so, what are the syntax requirements to do this ?
(3) What system changes are needed.
All help will be very welcome. Many Thanks, Michael.
declare CURSOR C1 IS
START_TIME,MINS,EXAM_DATE
SELECT I.SESSION_CODE,req_TIME,X_LENGTH,FULL_SESS,
FROM I.INVIG_SESSION I,X_SESSION X
WHERE I.SESSION_CODE = X.SESSION_CODE
AND X.SESSION_CODE IN (SELECT SESSION_CODE
FROM INVIG_SESSION
WHERE INVIG_SESSION.STUD_NO = '123456');
CREC C1%ROWTYPE;
FINISH NUMBER;
BEGIN
OPEN C1;
LOOP
FETCH C1 INTO CREC; EXIT WHEN CREC%NOTFOUND; MESSAGE (CREC.I.SESSION_CODE);
END LOOP;
END;
/ Received on Fri Mar 05 1993 - 10:31:38 CET