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]>