How can I ?

[Gheorghe Tihenea]

Hi,
I am evaluation your tool from C++ Builder 5 Entrprise. I have an Oracle 8.1.6i and my only access is trough some functions in a package. I did the wizard and now I have to C++ (and Delphi) code to access the functions I needed(BTW the generated code has some errors but they were easy to fix). Next I want to be able to get the result set (TOracleQuery) from one of my functions and to show it in a data aware grid (dbgrid). Is this possible ? If so, do you have a sample? I do not understand why a TOracleQuery cannot be used as a DataSet for a TDataSource ?
Thank you George

 

[Marco Kalter]

The TOracleQuery is just a low level encapsulation of an Oracle Cursor, it is not a Borland TDataSet component. To get a cursor result set for a packaged procedure, place the PL/SQL Block with the call in the SQL of a TOracleDataSet, and declare a cursor variable for the cursor parameter. The dataset will call the procedure when it is opened or refreshed, and will fetch the result set from the cursor.

The PkgApply example project demonstrates this.

------------------
Marco Kalter
Allround Automations