I began to switch but it doesn't seem to work.
Here is my procedure how it was written for the sql transformer
<execute-query xmlns="http://apache.org/cocoon/SQL/2.0";>
<query lang="1" isstoredprocedure="true">
begin dbchem.scheda_xml('<substitute-value sql:name="lingua"/>'
,?
,'<substitute-value sql:name="codice"/>'
,'<substitute-value sql:name="revisione"/>'
,''); end;
</query>
<out-parameter sql:nr="1" sql:name="resultset2"
sql:type="java.sql.Types.CHAR"/>
</execute-query>
Here is what I've written in xsp / Esql:
<esql:execute-query>
<esql:call>
{call procedure.tds_xml(<esql:parameter direction="in"
type="String"><xsp-request:get-parameter name="lingua"/></esql:parameter>,
<esql:parameter direction="out" type="String"/>,
<esql:parameter direction="in"
type="String"><xsp-request:get-parameter
name="codice"/></esql:parameter>,<esql:parameter direction="in"
type="String"><xsp-request:get-parameter name="revisione"/></esql:parameter>)}
</esql:call>
<esql:results>
<output>
<esql:call-results>
<esql:get-string column="1" from-call="yes"/>
</esql:call-results>
</output>
</esql:results>
</esql:execute-query>
And this is the error I get:
The org.apache.cocoon.www.sitemap_xmap notifies that
org.apache.cocoon.ProcessingException says:
Exception in ServerPagesGenerator.generate()
More precisely:
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.NullPointerException
The full exception stack trace says something like:
Original exception : java.lang.NullPointerException
at oracle.jdbc.ttc7.TTCAdapter.newTTCType(TTCAdapter.java:270)
at
oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCColumnArray(TTCAdapter.java:256)
at
oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCDataSet(TTCAdapter.java:231)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1363)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1602)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1527)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2045)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:395)
at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:446)
at
org.apache.cocoon.components.language.markup.xsp.EsqlQuery.execute(EsqlQuery.java:362)
at
org.apache.cocoon.components.language.markup.xsp.EsqlQuery.execute(EsqlQuery.java:336)
at
org.apache.cocoon.www.scheda_tecnica.oracletestesql_risposta_xml.generate(C:\Program
Files\tomcat\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www/scheda_tecnica\oracletestesql_risposta_xml.java:414)
at
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:258)
at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEventPipeline.java:250)
at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:399)
at
org.apache.cocoon.www.scheda_tecnica.sitemap_xmap.matchN400065(C:\Program
Files\tomcat\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www/scheda_tecnica\sitemap_xmap.java:716)
Thank you
On Fri, 06 Dec 2002 12:52:37 +0200, "Gabriele Domenichini"
<[EMAIL PROTECTED]> said:
> Thank you so much.
> I'll began the switching. If in the mean time a solution is found I'd
> prefere to use the sql transformer.
>
> On Fri, 6 Dec 2002 11:38:22 +0100, "Christian Haul"
> <[EMAIL PROTECTED]> said:
> > On 06.Dec.2002 -- 12:19 PM, Gabriele Domenichini wrote:
> > > I need to retrieve xml data from Oracle database as an out-parameter. The
> > > stored procedure works but the output is like this:
> > > <rootElement>
> > > <element>
> > > Something written
> > > </element>
> > > </rootElement>
> > > I think that SQL Transformer convert "<" and ">" signs in entities. I
> > > need desperately to have my code back. Please help me
> >
> > No idea how to achieve this with the transformer, but with esql you
> > could use esql:get-xml for this (or enclose a get-string with
> > util:include-expr).
> >
> > Switching to XSP would surely have a major impact but since you are
> > desparate....
> >
> > I believe there has just been a similar thread, so have a look at the
> > archives.
> >
> > 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]>
> >
> >
> --
> Gabriele Domenichini
> [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]>
>
>
--
Gabriele Domenichini
[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]>
