Re: loadercli shows *no line numbers* for syntax error messages i n dbprocs

   Two questions : if loadercli is not an SQL tool,
which tool should I be using (on linux) to devellop my stored procs ?

   I just need some tool to take a file filled with stored procs
run it, and give me a line number for the syntax errors.

  loadercli seems to be the closest to this, but would it make more
sense to 'enhance' ireport.py to 'feed' from files ?

  Please tell me, and I'll go agead and implement it,
also by looking at loadercli's source, it wasn't immediately
clear where the best place would be to add this, so
a hint on this would be helpfull.

  Thanks


Schildberg, Steffen wrote:
> Hi MAX,
> 
> MAX [mailto:[email protected]] wrote:
> 
>>Subject: loadercli shows *no line numbers* for syntax error 
>>messages in dbprocs
>>
>>
>>
>>  It erpors messages like  :
>>
>>   Error position : 2801
>>
>>  as if the dbproc was a single line string...
>>
>>
>>  Of course one would expect line number *AND* character 
>>position number,
>>
>>  but whoever wrote loadercli, or loadercli's parser thought 
>>otherwise.
>>
> 
> Nope, he did not. See below.
> 
> 
>>  To debug a procedure I had to put it all on a
>>single line to no what the actial "error position" was...
>>  This is mindbogling...
>>
> 
> It is indeed.
> 
> 
>>  Please tell me there's a way to add this "functionnality" !
>>
> 
> That's easy. You only need to modify the kernel itself.
> The loader simply 'routes' SQL commands to the kernel without
> parsing them at all (it is definitely not an SQL tool as already
> stated here in the group).
> So the error message comes directly from the kernel.
> 
> Regards,
>  Steffen