Recent content by Chrisdaems

Hello Marco, You're totally right. I didn't wrote If not ((MyOracleDataset.datasource.dataset) in [dsedit]) then MyOracledataset.edit; But i wrote If not ((MyOracleDataset.datasource.dataset.state) in [dsedit]) then MyOracledataset.edit; then the access violation appears. But you gave me the...

Hello, I am getting an Access Violation everytime when i try to check the state of a TOracleDataset. The access violation appears when i try to execute following code: If not ((MyOracleDataset.datasource.dataset) in [dsedit]) then MyOracledataset.edit; When I don't check the state then...

Hi Marco, Package PkgApply isn't so dynamic. I tried to do it like this but the SQL isn't dynamic at all. For every field they used a new query. I don't think that ORCALE can handle Dynamic SQL in a STRONG ref cursor. It is possible in a WEAK ref cursor but then I have problems with DOA. Isn't...

Hi, I have some problems with sorting columns of a DBGrid in Delphi. I have a Dataset that executes a stored procedure on the Oracle server. The stored procedure has a out parameter with datatype Ref Cursor. The order by in the SQL is filled with a parameter. But I know that this is the...

Hi, I have some overloading problems. A possible solution could be RECORD TYPES, but does DOA support record types as parameters to call stored procedures? I will give an example what will describe the problem. -- --------------------------- -- PLSQL -- --------------------------- Procedure...

I have one DBGrid where I show results from certain queries. In fact the queries are stored procedures written on the oracle server. I try to select records and show the resultset in a dbgrid. On the form I have a listbox with some tablenames in. When I click on one of the items the DBGrid shows...

I am new to DOA and I have some overlaoding problems. I wrote some overloaded stored procedures on the oracle server. The datatypes are ref cursors based on a record. So for pl/sql it are different types. But when I try to call those procedures I have to declare the variables. To achieve this I...