Re: PL/SQL run from SQL*Plus
Date: 8 Mar 93 08:32:36 +1100
Message-ID: <1993Mar8.083236.646_at_hhcs.gov.au>
In article <1993Mar5.093138.1_at_vax1.tcd.ie>, mcgrathm_at_vax1.tcd.ie writes:
>
>
> Hi Folks,
>
> I wish to run a PL/SQL script from SQL*PLUS. However
> I am getting error messages such as:-
>
>
> Unknown command beginning "Cursor .." rest of line ignored
>
> 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.
Here's your problem:
You forgot the BEGIN at the top of the PL/SQL block
>
> declare CURSOR C1 IS
> SELECT I.SESSION_CODE,req_TIME,X_LENGTH,FULL_SESS,
> START_TIME,MINS,EXAM_DATE
> 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;
> /
/\ Steven Champness (champs_at_hhcs.gov.au)
/ \ Dept Health Housing and Community Services
/ \ Brisbane Queensland
/ \ via
/ / \ Canberra Australia
\ / / /
\/ / / / MACINTOSH SOFTWARE AXIOM : If you need a manual to operate it
\/ / / it wasn't designed properly in the \/ / first place !\/ Received on Sun Mar 07 1993 - 22:32:36 CET