Hi 
Thank you for your reply, but I am not agree:
1. Both errors in the example are runtime errors! Or more precisaly: Who
decides, which error ist a syntax or runtime error? 
2. We loose a lot of transparency, when eslq decides about errors during
runtime.
Regards 
Sarah Windler

-----Original Message-----
From: Christian Haul [mailto:[EMAIL PROTECTED]] 
Sent: Montag, 13. Januar 2003 10:38
To: [EMAIL PROTECTED]
Subject: Re: sql errors and esql


On 13.Jan.2003 -- 09:47 AM, Sarah Windler wrote:
> Hi
> I don't understand, why some sql errors goes through the
> esql:error-results pipe and others not. 
> For example:
> 1. SQL> select mgmt_ip_addressm from v_ps_port_traffic;
> select mgmt_ip_addressm from v_ps_port_traffic
>        *
> ERROR at line 1:
> ORA-00904: "MGMT_IP_ADDRESSM": invalid identifier
> 
> 2.SQL> select  mgmt_ip_address from v_ps_port_traffic;
> select  mgmt_ip_address from v_ps_port_traffic
>                                              *
> ERROR at line 1:
> ORA-04063: package body "PORTSTATS.PS_PKG_UTL" has errors
> 
> The first sql error goes to the esql:error-results pipe, but the 
> second error switches to the esql:results pipe.I don't understand from

> the source code of esql, why I don't receive all sqlplus errors 
> transparently. We have installed Cocoon-2.0.4.

Syntax & other setup errors do not go to the esql:error-results while
run-time errors do. At least, that's the way it should be.

        Chris.
-- 
C h r i s t i a n       H a u l
[EMAIL PROTECTED]
    fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>


---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Reply via email to