Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-06550: PLS-00103: Encountered the symbol "."

Re: ORA-06550: PLS-00103: Encountered the symbol "."

From: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Thu, 22 Jan 2004 15:07:13 -0000
Message-ID: <MPG.1a79f77e8c1ebe22989a2a@news.individual.net>


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

-- 
jeremy
Received on Thu Jan 22 2004 - 09:07:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US