I had this stored procedure running well with SQL Transformer:
<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>
I have to convert it to ESQL because the out parameter is xml.
I've tried everything and the most possible candidate to work is the
following:
<esql:execute-query>
<esql:call>
{call dbchem.scheda_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>,
,'0')}
</esql:call>
<esql:results>
<esql:call-results>
<esql:get-xml column="1" from-call="yes"/>
</esql:call-results>
</esql:results>
</esql:execute-query>
The error is:
The org.apache.cocoon.www.sitemap_xmap notifies that
org.apache.cocoon.ProcessingException says:
Exception in ServerPagesGenerator.generate()
Original exception : java.lang.NullPointerException
at
org.apache.cocoon.components.language.markup.xsp.EsqlQuery.<init>(EsqlQuery.java:99)
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:306)
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)
Is there something that I could try?
Should I upgrade to cocoon 2.0.4?
Thank you anyway
--
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]>
