Re: line overflow during variable substitution (>3000 characters at line 1)

From: Jin Bo <jinbo_at_hpsgns1.sgp.hp.com>
Date: Tue, 03 Aug 1999 13:42:13 +0800
Message-ID: <37A68135.AB30DEA6@hpsgns1.sgp.hp.com>

break sql statement inot multiple lines.

Hth
bjin

Juan Carlos wrote:

> I'm getting this error message running a SQL Plus script. The only thing a
> little unusual that I am doing is I have a where clause that has a long list
> of specific check numbers I am retrieving from the database as such:
>
> and ( ( check_no = '010400' and check_dt = '03-jan-98')
> or ( check_no = '010410 and check_dt = '06-jan-98')
> ...
> ...
>
> for about 156 times.
>
> Could this be the problem?
Received on Tue Aug 03 1999 - 00:42:13 CDT