Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-06550: PLS-00103: Encountered the symbol "."
In article <buoogs$c9e$1_at_ork.noris.net>, rupa_at_firemail.de says...
> Dear DBA,
>
> I want to execute the following Script:
> sqlplus -s /nolog << EOF >>$LOGFILE
>
> CONNECT system/manager
>
> SET SERVEROUTPUT ON
>
> SET ECHO OFF FEEDBACK OFF TERMOUT OFF HEADING OFF VERIFY OFF
>
> SPOOL backupdatei.sh
>
> DECLARE
> CURSOR c_ts is SELECT tablespace_name FROM dba_tablespaces;
> CURSOR c_df (v_tablespace_name IN VARCHAR2) is
> select file_name FROM dba_data_files
> WHERE tablespace_name = v_tablespace_name;
>
> BEGIN
> dbms_output.put_line('./switch_log.sh');
> FOR r_ts IN c_ts LOOP
>
> dbms_output.put_line('./begin_backup.sh ' || r_ts.tablespace_name);
>
> FOR r_df IN c_df(r_ts,tablespace_name) LOOP
> dbms_output.put_line('./end_backup.sh' || r_df.filename);
> END LOOP
I think you're mising the ; at the end of two your END LOOP
-- jeremyReceived on Thu Jan 22 2004 - 09:07:13 CST