U++ framework
Do not panic. Ask here before giving up.

Home » U++ Library support » U++ SQL » Is it possible to call a stored procedure with an output parameter?
Re: Is it possible to call a stored procedure with an output parameter? [message #35424 is a reply to message #35419] Sun, 12 February 2012 08:56 Go to previous messageGo to previous message
jjacksonRIAB is currently offline  jjacksonRIAB
Messages: 227
Registered: June 2011
Experienced Member
I'm not quite sure I understand callbacks in the context of a database query.

How I normally call a stored procedure in DTL:

Parameters params;
params.A = "something";
params.B = "something";

// params.C is an output parameter

// BPA is just a parameter mapping structure, similar to .sch file
DBView<Parameters> view (
    "{call stored_procedure_x (?, ?, ?)}",
    stored_procedure_bpa()
    );

// Create an iterator pointing to the view
DBView<Parameters>::sql_iterator sprocIter = view.begin();

// Copy params into the stored procedure iterator
*sprocIter = params;

// In DTL, incrementing an iterator executes stored procedure
++sprocIter;

// Now sprocIter->C will hold results from calling the stored procedure


How do you do this in Ultimate++?
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: questions about sqlArray
Next Topic: SQL problem
Goto Forum:
  


Current Time: Fri Oct 02 18:28:07 GMT+2 2026

Total time taken to generate the page: 0.03002 seconds