Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g43g2000cwa.googlegroups.com!not-for-mail
From: "Wally" <wallyraju@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Why would concatenating a variable to a variable give an error in pl/sql?
Date: 6 Jun 2005 14:19:31 -0700
Organization: http://groups.google.com
Lines: 8
Message-ID: <1118092771.951605.260960@g43g2000cwa.googlegroups.com>
References: <42a4b693$0$50296$bb4e3ad8@newscene.com>
NNTP-Posting-Host: 57.80.136.6
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1118092777 29686 127.0.0.1 (6 Jun 2005 21:19:37 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 6 Jun 2005 21:19:37 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g43g2000cwa.googlegroups.com; posting-host=57.80.136.6;
   posting-account=x8Hw5w0AAACrsxsfzRabl6H8S9TZVMT7
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:244379

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.