Topic
  • No replies
FX02_Paulo_TOVO
FX02_Paulo_TOVO
1 Post

Pinned topic Error SQLBINDCOL in Stored Procedure with comments between parameters

‏2013-08-07T20:33:40Z |

Hi,

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????

Thanks.

 

Paulo