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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]