Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news-FFM2.ecrc.net!newsfeed00.sul.t-online.de!newsmm00.sul.t-online.de!t-online.de!news.t-online.com!not-for-mail
From: Maxim Demenko <mdemenko@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Why would concatenating a variable to a variable give an error
 in pl/sql?
Date: Mon, 06 Jun 2005 23:53:03 +0200
Organization: T-Online
Lines: 18
Message-ID: <d82gjj$qsu$02$1@news.t-online.com>
References: <42a4b693$0$50296$bb4e3ad8@newscene.com> <1118092771.951605.260960@g43g2000cwa.googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: news.t-online.com 1118094771 02 27550 jR32rUCrEQkm0l1 050606 21:52:51
X-Complaints-To: usenet-abuse@t-online.de
X-ID: Z4V+s-ZHZe0hFFI3Fyz+otVgxYfyfNctl1QgyLyPw8LUYb-tTHDfEh
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: de-DE, de, en-us, en
In-Reply-To: <1118092771.951605.260960@g43g2000cwa.googlegroups.com>
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:244386

Wally schrieb:
> well, apart from what ever code you took out for brevity, the code
> compiled fine for me on Oracle 8i/ Win2k after i put the line
> 
> sqlStmt :='insert into
> cas_data_tmp(lo...................................
> 
> all in one line.
> 

Just wondering how did you manage to compile that code despite the line 
you mentioned contains the string that is not properly quoted... ( or is 
it my mail client, that annihilates some quotes ...)


Best regards

Maxim