Re: executing sql code with SQLPlus

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Tue, 10 May 2005 02:06:53 GMT
Message-ID: <Xns9651C272468BBSunnySD@68.6.19.6>

Vince <vincent@<remove>.> wrote in
news:f01v71lvbbrt496gog16mluv5h5r0qotgc_at_4ax.com:

> On Mon, 09 May 2005 17:32:23 +0200, Frank van Bortel

><fvanbortel_at_netscape.net> wrote:

>

>>Vince <vincent@ wrote:
>>> On Mon, 09 May 2005 17:09:16 +0200, Frank van Bortel
>>> <fvanbortel_at_netscape.net> wrote:
>>> 
>>> I tried the 'show errors' in my PL block, but nothing appears..it
>>> stays up with a number line as if it didn't execute anything :-/
>>> 
>>> ++
>>> Vince
>>> 
>>
>>please, do not top post.
>>
>>Post (a part of) the code, as you use it (cut / paste)

>
> code is quite long, I don't think u gonna enjoy read it..:-/
> it consists in creating 3 tables and a stored proc..and successfully
> compile in SQLWorsheet.
> thank you anyway :)
> ++

Another possible alternative is to comment out 1/2 the code. Do you still get error. Comment out 1/2 the remaining lines. Simply do a binary search to isolate the line that is causing the problem.

HTH & YMMV! Received on Mon May 09 2005 - 21:06:53 CDT