cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gabriele Domenichini" <gabrid...@fastmail.fm>
Subject Oracle SP with ESQL an c2 2.0.3
Date Tue, 10 Dec 2002 10:26:23 GMT
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
  gabridome@fastmail.fm

---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message