cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anna Bikkina <>
Subject Stored Procedure and esql
Date Mon, 23 Feb 2004 23:13:22 GMT

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 

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

			  <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:result><xsp:expr>(ResultSet)<esql:get-object column="1" 
				        <esql:get-string column="1"/>

Thanks in advance

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message