Re: HELP! PL/SQL

Answers embedded

Hth,

Sybrand Bakker, Oracle DBA

"Ho" <kowho_at_singnet.com.sg> wrote in message news:8oahrq$3vi$2_at_clematis.singnet.com.sg...
> I write a sql called top.sql. It contains:
>
> @c:a.sql
> @c:b.sql
> @c:c.sql
>
>
> After each execution, Oracle will display procedure completed
> successfully. 1 record deleted ; 1 record inserted.
>
> Q1)How can I suppress of the above status message ?
>

rem read the sql*plus manual
set feedback off

> c.sql is as follows :
>
> DECLARE
> FILE_HANDLE UTL_FILE.FILE_TYPE;
> v_a char(1);
> V_B NUMBER(2);
> BEGIN
> select answer into v_a from yesno;
> FILE_HANDLE := UTL_FILE.FOPEN('C:','ANS.TXT','W');
> UTL_FILE.PUT_LINE(FILE_HANDLE,v_a);
> UTL_FILE.FCLOSE(FILE_HANDLE);
> BEGIN
> select DAY into v_B from TEST;
> FILE_HANDLE := UTL_FILE.FOPEN('C:','DAY.TXT','W');
> UTL_FILE.PUT_LINE(FILE_HANDLE,v_B);
> UTL_FILE.FCLOSE(FILE_HANDLE);
> END;
> END;
>
> Q2. Why the execution of c halt at line 17 instead of returning to
> sql> ?

Because you don't have a / or a blank line following the last end;

> Q3. If I copy the whole sql & paste into sql screen and type / , it is
> being executed successfully and return to sql>. Why ????

Because that's the way it works! / means 'run buffer'. An extra blank line would have had the same result.

>
> Many thanks for your help in advance.
>
>
>
>
>
>
>
>
Received on Sun Aug 27 2000 - 03:49:31 CDT