I have a stored procedure created in the informix following format:
CREATE PROCEDURE spr_test(p_type SMALLINT,p_cod CHAR(2),/*Here i have the comments about the next vars*/p_cond_esp CHAR(1),p_cond_key CHAR(1))RETURNING CHAR(1);RETURN "f";END PROCEDURE;
I have a application in c++ that execute this procedure.
1) Execute SQLProcedureColumns and return ok.
2) Execute SQLBindCol and return ok
3) Execute SQLFetch(stmt) and return 2 rows with state 0(SUCCESS) and after, return 100 (NO_SQl_DATA). The last parameters after comments is not return ok.
When i remove the comments between parameters in the stored procedure, the problem does not happens.
When i insert the comments with "//" , the problem does not happens too.
Whats the problem????