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

From: Roman Klesel <rupa_at_firemail.de>
Date: Thu, 22 Jan 2004 15:59:26 +0100
Message-ID: <buoogs$c9e$1@ork.noris.net>

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

         dbms_output.put_line('./end_backup.sh' || r_ts.tablespace_name);
         END LOOP;

END;
/

I get the following error:

         dbms_output.put_line('./end_backup.sh' || r_ts.tablespace_name);
                    *

ERROR at line 17:
ORA-06550: line 17, column 13:
PLS-00103: Encountered the symbol "." when expecting one of the following: ;
ORA-06550: line 18, column 2:
PLS-00103: Encountered the symbol "END"

I understand little of PL/SQL so I have no clue what's wrong. I took the script from an book.
I executed catproc.sql but the problem persists.

PLS help me to clarify this.

Greets Roman Received on Thu Jan 22 2004 - 08:59:26 CST