OracleScript output

[LGEAI Developers]

Using DOA 4.0.3 and trying to use the OracleScript component. I set up a test button with the following Delphi 7 code:

procedure TFRIA0024frm.btnExecSqlScriptClick(Sender: TObject);
begin
FRIA0024dm.OracleScript1.Execute;
end;

String List Editor has the following:

select count(*) as audit_id
from ri_audits
where ri_audit_id = 62659;

select count(*) as nbr_trans
from edi_transactions
where ri_audit_id = 62659;

select count(*) as nbr_acks
from edi_acknowledgements
where editrn_ri_audit_id = 62659;

How do I see the output like PL/SQL Developer Command window?

SQL>

AUDIT_ID
----------
1

NBR_TRANS
----------
44

NBR_ACKS
----------
3

SQL>

Thanks in advance.
Bruce

 

[Marco Kalter]

If you include ooData in the TOracleScript.OutputOptions property, the result set will be included in the Output.

 

[LGEAI Developers]

Thank you for your response.

All output parameters are set to true. Where does the output go?

 

[Marco Kalter]

To the TOracleScript.Output property, which is a TStringList. You can alternatively use the OnOutput event to process the output as it occurs (instead of afterwards).