🚀 go-pugleaf

Hi,

never mind my first question, I guess I have to use the TStoredProc control:
        StoredProcSP->DatabaseName = "dbXX";
        StoredProcSP->ParamsByName("ParamA")->AsString = "a";
        StoredProcSP->ParamsByName("ReturnCode")->AsString = "";
        StoredProcSP->ParamsByName("ErrorString")->AsString = "";
        StoredProcSP->StoredProcName = "proc_x";
        StoredProcSP->Prepare();
        StoredProcSP->ExecProc();
        strReturnCode = StoredProcSP->ParamByName("ReturnCode")->AsString;
        strErrorStr = StoredProcSP->ParamByName("ErrorString")->AsString;

where i use specified all my parameters, such as the name, type, etc.

does this give me the ReturnedCode and ErrorString?  it keeps giving me a
'Syntax error or access violation' error when i try to execute the procedure
at ExecProc().  another questions is, since i am already logged onto the
database, is there a way to make that dialog box (asking for username,
password at Prepare()) disappear?

Thanks much
Jerri Chiu


"Jerri Chiu" <jeje@home.com> wrote in message news:3b536117$1_2@dnews...
> Hi,
>
> I want to execute a PL/SQL procedure using a TDataSource + TQuery like
this:
> strSQL.sprintf("CALL proc_x"
>                 "('%s', %s, %s)",            <=??
>                 strParam.c_str(),
>                 strReturnCode.c_str(),    <=??
>                 strErrorString.c_str());    <=??
>
> qUpdate->SQL->SetText(strSQL.c_str());
> qUpdate->ExecSQL();
>
> where proc_x returns a ReturnCode and an ErrorString, I would like to use
> strReturnCode and strErrorString to store these returned values, how do I
> rephrase my sprintf statement?  in other words, how should the proc_x be
> called?
>
> Thanks much
> Jerri Chiu
>
>