What I'm using:
1. Delphi 5
2. DOA 3.4
3. Oracle 8i
What I am doing:
Trying to make a Oracle Stored Procedure, with a cursor, updateable on a DCOM client.
The Stored Procedure:
It's a simple SELECT statement with a WHERE & ORDER BY clauses, returning the cursor as the last parameter.
What I have been doing:
On the client side I have a TClientDataset that is connected to a TDatasetProvider on the server, using a TDCOMConnection. The TDatasetProvider.DataSet property is a TOracleDataset. The TOracleDataset.SQL property looks something like this:
------------------
begin
Owner.Packet.ProcedureName(InputParameter1, InputParameter2... InputParameterN, CursorParameter);
end;
------------------
The TOracleDataset.UpdatingTable property is set to the same table that the procedure is selecting from.
What my problem is:
When I do the TClientDataset.ApplyUpdates(-1), I get the error message "Catastrophic Failure" (doesn't tell me much!).
Note:
I have tried using the same TOracleDataset object alone (without the TDatasetProvider & TClientDataset) and then everything works fine, so this has something to do with the DCOM part (has probably someting to do with the way the Cursor is handled).
Has anybody been doing something like this with success?
Any help would be greatly appreciated,
Thanks in advance.
Sveinn Thorsteinsson.
1. Delphi 5
2. DOA 3.4
3. Oracle 8i
What I am doing:
Trying to make a Oracle Stored Procedure, with a cursor, updateable on a DCOM client.
The Stored Procedure:
It's a simple SELECT statement with a WHERE & ORDER BY clauses, returning the cursor as the last parameter.
What I have been doing:
On the client side I have a TClientDataset that is connected to a TDatasetProvider on the server, using a TDCOMConnection. The TDatasetProvider.DataSet property is a TOracleDataset. The TOracleDataset.SQL property looks something like this:
------------------
begin
Owner.Packet.ProcedureName(InputParameter1, InputParameter2... InputParameterN, CursorParameter);
end;
------------------
The TOracleDataset.UpdatingTable property is set to the same table that the procedure is selecting from.
What my problem is:
When I do the TClientDataset.ApplyUpdates(-1), I get the error message "Catastrophic Failure" (doesn't tell me much!).
Note:
I have tried using the same TOracleDataset object alone (without the TDatasetProvider & TClientDataset) and then everything works fine, so this has something to do with the DCOM part (has probably someting to do with the way the Cursor is handled).
Has anybody been doing something like this with success?
Any help would be greatly appreciated,
Thanks in advance.
Sveinn Thorsteinsson.
