Re: PLSQL function returning CLOB

2002-07-05 Thread Denis Thierry

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 functions.


Hope this will help to understand what is wrong!

Denis
- 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.SQLException: ORA-06550:
rivi
 1, sarake 35: PLS-00382: lauseke on väärän tyyppinen ORA-06550: rivi 1,
sarake
 15: PL/SQL: Statement ignored

It would really help to understand the error message. There should be
a locale setting for your connection.

Another helpful thing would be a sample java code that would achieve
the same as you're trying to do. Maybe Oracle provides some snippets?

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]




Re: C2.0.3 ESQL: esql:get-columns/

2002-07-02 Thread Denis Thierry

Argyn,

You will need to convert your data (xsltransform) with:

xsl:for-each select=node()
  column
xsl:attribute name=name
  xsl:value-of select=local-name()/
/xsl:attribute
  /column
/xsl:for-each

Hope this help

Denis
- Original Message - 
From: Argyn Kuketayev 
To: Cocoon-Users (E-mail) 
Sent: Tuesday, July 02, 2002 5:37 PM
Subject: C2.0.3 ESQL: esql:get-columns/ 


I've two questions:

1. esql:get-columns/ generates: col1val1/col1col2val2/col2...

how to make it generate this? column name=col1val1columncolumn
name=col2val2column...

2. If my string value of the coulmn contains tags, e.g. html tags like
val1br, will XSP generate a valid xml document?
Re-phrasing: how to make it return this? column
name=col1![CDATA[val1br]]

thanks

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




Re: Warming the cache.

2002-06-25 Thread Denis Thierry

First have a look at
http://xml.apache.org/cocoon/performancetips.html

Then, look also at the run.sh|bat command line to run cocoon without web
interface.
That way, you can easily design cronjobs to get it running at scheduled
times over nights

Regards,

Denis


- Original Message -
From: David Vos
To: [EMAIL PROTECTED]
Sent: Tuesday, June 25, 2002 5:40 PM
Subject: Warming the cache.


As we are moving more of our web site over to cocoon, we are starting to
run into some speed issues.  There are several ways we could speed things
up from a processing side (split some of our xml files up to drastically
speed up parsing), however there are some things that may take at least 10
minutes to complete (dynamically generating microsoft reader format for
files larger than a megabyte).  Therefore, it would be nice to have cocoon
generating all of these overnight so that as they are being accessed,
response time will be much quicker.

What might be the best way to do this (besides a script calling wget
http://localhost/... all night?).

How large can the cocoon cache grow?

David


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




POI Serializer - IE 6.0 and MS Excel 2000

2002-05-31 Thread Denis Thierry

Hi all,

I'm actually using cocoon to generate report as  MS Excel doc and I do
expirience a strange behaviour. The produced files is sometime opened within
IE 6.0 and sometime outside (eg MS Ecel standalone). Is there any logic
behind? Genereated files are ont big at all (about few 10ko ...).
Does anybody already experienced it?

Denis


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

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