An incorrect workaround when using stored procedures.

Stored Procedure | error | Resolution


This period of time with C + + Builder, in the call stored procedures encountered some problems, asked a lot of places did not find the answer, and finally rely on their own, now take out and share.





Sample code:





storedproc1->params->clear ();


Storedproc1->params->createparam (Ftsmallint, "@m1", ptinput);


Storedproc1->params->createparam (ftstring, "@m2", ptoutput);


Storedproc1->params->createparam (Ftinteger, "@m3", ptoutput);


Storedproc1->params->createparam (Ftinteger, "@m4", ptoutput);


Storedproc1->params->createparam (Ftinteger, "@m5", ptoutput);


  


Storedproc1->params->createparam (Ftinteger, "result", Ptresult);


Storedproc1->prepare ();


Storedproc1->execproc ();








problem: Call stored procedures always error, attention, when executing storedproc1->execproc () will be an error, the other local reported the wrong solution is no longer this article. Error message when executing code errors hint: Error: Indicator variable required but not supplied





reason: This problem occurs when the stored procedure is executed, if there is an empty value of the item





solution: In the stored procedure for the production of null value processing, it can be