Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> line overflow during variable substitution (>3000 characters at line 1)

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

From: Juan Carlos <jc_va_at_hotmail.com>
Date: Mon, 2 Aug 1999 19:43:57 -0700
Message-ID: <7o5ano$122$1@bgtnsc01.worldnet.att.net>


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 Mon Aug 02 1999 - 21:43:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US