Stored Procedure and esql

[Anna Bikkina <an...@pinksheets.com>]

Hi,

I am trying to run a stored procedure using esql in cocoon. I guess I am 
having a syntax error. 

Please let me know where I am going wrong. I am using the informix database.I 
checked the storedprocedure using dbaccess and that runs. 

 I get an error saying
 
"Function doesn't have an output parameter or the out parameter isn't 
returned."

Should I mention ouput parameters somewhere? I tried to use the INTO clause in 
esql:call but it did not help.  

		<esql:connection>
			  <esql:pool>myserver</esql:pool>
			  <esql:execute-query>
			  <esql:call  needs-query="true">{call myproc(90489,'2004-02-13 
00:00:00','2004-02-13 23:59:59',1,1,1)}</esql:call>
				<esql:call-results>
				  <esql:use-results>
				    <esql:result><xsp:expr>(ResultSet)<esql:get-object column="1" 
from-call="true"/></xsp:expr></esql:result>
				    <esql:results>
				      <esql:row-results>
				        <esql:get-string column="1"/>
				      </esql:row-results>
				    </esql:results>
				  </esql:use-results>
				</esql:call-results>
				</esql:execute-query>
			</esql:connection>



Thanks in advance
Anna.



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org