Re: PLSQL function returning CLOB

2002-07-05 Thread Christian Haul
On 05.Jul.2002 -- 04:16 PM, [EMAIL PROTECTED] wrote: > getAscii(java.sql.CallableStatement, int) not found in class > org.apache.cocoon.components.language.markup.xsp.EsqlHelper" For the record: fixed in CVS (2.0.3 and HEAD) Chris. -- C h r i s t i a n H a u l [EMAIL PROTECTED]

Re: PLSQL function returning CLOB

2002-07-05 Thread Christian Haul
On 05.Jul.2002 -- 02:52 PM, Denis Thierry wrote: > >From oracle: > > PLS-00382 expression is of wrong type > > Cause: An expression has the wrong datatype for the context in which it was > found. > > Action: Change the datatype of the expression. You might want to use > datatype conversion func

PLSQL function returning CLOB

2002-07-05 Thread Jarmo . Blomster
Hi, I use oracle 8.1.7.3 in W2k, JDBC 2 oracle classes using oci8 driver, Tomcat 4.0.4, and Cocoon 2.1-dev. It works fine with varchar2, and string How should I handle a CLOB in included example. There is also commented the esql:get-ascii tag, that gives annother error message, but lets handle

Re: PLSQL function returning CLOB

2002-07-05 Thread Jarmo . Blomster
ase respond to [EMAIL PROTECTED]; Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: Jarmo Blomster/CCC) Subject: Re: PLSQL function returning CLOB On 05.Jul.2002 -- 03:07 PM, [EMAIL PROTECTED] wrote: > Sorry about the finnish > statement: begin ? := test.tst3; end

Re: PLSQL function returning CLOB

2002-07-05 Thread Jarmo . Blomster
Hi, I think it helped, I think it now understands this CLOB, but the problem is now that I can't get the value of it: the out commented part now bite me like this: http://apache.org/xsp"; xmlns:esql="http://apache.org/cocoon/SQL/v2"; > A Simple XSP Page sapjeda

Re: PLSQL function returning CLOB

2002-07-05 Thread Denis Thierry
nis - Original Message - From: Christian Haul To: [EMAIL PROTECTED] Sent: Friday, July 05, 2002 2:37 PM Subject: Re: PLSQL function returning CLOB On 05.Jul.2002 -- 03:07 PM, [EMAIL PROTECTED] wrote: > Sorry about the finnish > statement: begin ? := test.tst3; end; : java.sql.SQLExcep