🚀 go-pugleaf

John 

	Try this
 ADOCommand1->Connection = ADOConnection1;
ADOCommand1->Parameters->Clear();
ADOCommand1->CommandText = WideString(Text);
//Text = "util.set_psm_ack(3456,321,'Testing..')";
ADOCommand1->CommandType = cmdStoredProc;
ADOCommand1->ParamCheck = false;
ADODataSet2->Recordset = ADOCommand1->Execute();


On Mon, 20 Aug 2001 15:56:22 GMT, mcdonald@airtalk.com (John McDonald)
wrote:

>Hi,
>
>I am trying to execute a stored procedure in Oracle 8i that
>returns an integer value.  I can get the stored procedure
>to execute OK but I cannot find the return value anywhere???
>
>
>    ADOCommand1->Connection = ADOConnection1;
>    ADOCommand1->Parameters->Clear();
>    ADOCommand1->CommandText = WideString(Text).Detach(); 
>       //Text = "util.set_psm_ack(3456,321,'Testing..')";
>    ADOCommand1->CommandType = cmdStoredProc;
>    ADOCommand1->ParamCheck = false;
>    ADOCommand1->Execute();
>    ADODataSet2->Recordset = ADOCommand1->Execute();
>
>Everytime ADODataSet2->Recordset = ADOCommand1->Execute(); 
>executes I recieve a stack overflow exception.  How can I
>retrieve the results from the stored procedure?? 
>
>Thx,
>
>John