Error when executing INSERT and SELECT-statement at once
Posted by: Stefan Kögl
Date: March 11, 2005 01:52AM

Hello,

I get a Microsoft.Data.Odbc.OdbcException when i try to execute a statement like

INSERT INTO tab (cols) VALUES (vals);
SELECT LAST_INSERT_ID() FROM tab LIMIT 1;

at once via the .NET Connector. The exception accurs in the method OdbcCommand.ExecuteReader(). The additional information is something like "system error" ("Systemfehler" in German).
Can anybody help me?

Thanks, Stefan

Options: ReplyQuote


Subject
Written By
Posted
Error when executing INSERT and SELECT-statement at once
March 11, 2005 01:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.