ORA-22816 unsupported feature with RETURNING clause

[walter]

(I use Delphi 6 and Oracle 8.1.7.4.09)

Dataset with a remote Table...

I have a TOracleDataset with the sql-statement
"select a.rowid,a.* from XY", XY is a synonym for a remote table (oracle 9.2.0.4).

When i try to insert data true a Grid or true dbedit fields i get the error-message
"ORA-22816 unsupported feature with RETURNING clause"
When i try to insert data true an insert-statement (insert into xy (..) values (...))
it works...

walter

 

[Marco Kalter]

What happens if you set the UniqueFields property of the dataset to the names of the fields that idintify the records? You need to separate the fields with semi-colons.

 

[walter]

Originally posted by Marco Kalter:
What happens if you set the UniqueFields property of the dataset to the names of the fields that idintify the records? You need to separate the fields with semi-colons.

The error-message change in :
"INVALID VARIANT OPERATION"

walter

 

[Marco Kalter]

What is your Direct Oracle Access version?

 

[walter]

Originally posted by Marco Kalter:
What is your Direct Oracle Access version?

Thank you for your interest!

I have installed Version DOA 3.4.5 with Delphi Professional 6.0 Build (6.2.40) Update Pack 2.

We use Doa now for 2 years and i am very statisfied with your product.
We start now some Projects with distributed DB's and it would be a great help (for me...) if DOA works in cases like this...

walter

 

[Marco Kalter]

Can you apply the latest 3.4.6 release? I think this will fix the variant error.

 

[walter]

Originally posted by Marco Kalter:
Can you apply the latest 3.4.6 release? I think this will fix the variant error.

Great, it works...

Thank you

walter