Hi,
This is the example code for invoking stored procedures.
CSpProcedure loadTable = (CSpProcedure)CSpider.getDataObject
("LoadTables");
loadTable .clearAllValues ();
// Execute the stored procedure and check for success
// and that no event requested us to stop
int command = loadTable.execute ();
if (loadTable.succeeded () && (command != STOP))
{
CSpLog.send(this, CSpLog.HIGH_LEVEL, "Stored procedure executed
successfully");
// Check the return code. TRUE means success.
boolean result = loadTable.getValue (0,"success").booleanValue ();
}
-------------------------------------------------------------------------------------------------------
--- boolean result = loadTable.getValue (0,"success").booleanValue
(); ---
I have declared an 'OUT ' parameter in my stored procedure and I am
initializing and returning a variable 'success'
to 'TRUE' or 'FALSE' as the case may be.
How do I check the value returned ? How do I set the value in the
properties dialog of the data object .
I assume that this is a parameter.
bye,
Mohan
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
