Re: First attempt with Dynamic SQL

On Sat, 17 Apr 2004 22:46:17 +0200, Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote:

>Your commandline wraps. You can't wrap a string literal across a line.
>The string literal needs to end in a '|| and continue with '
>on the next line.

 Was this a limitation in previous versions? It doesn't appear to be true any more.

SQL*Plus: Release 9.2.0.5.0 - Production on Sat Apr 17 21:44:46 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> set serveroutput on
SQL> begin
  2 dbms_output.put_line('multi
  3 line
  4 literal');
  5 end;
  6 /
multi
line
literal

--
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk         / http://www.andyhsoftware.co.uk/space