DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

cannot perform a DML Operation inside a query

185024Dec 6 2002 — edited Dec 17 2002

hi,
I've got the following problem while calling a stored proc which is using a dml Op inside:

OraOLEDB
-2147467259
?err.Description
ORA-14551: cannot perform a DML operation inside a query
ORA-02041: client database did not begin a transaction
ORA-06512: at line 1

If I call the Procedure from TOAD or SQL Plus, it works fine.

Is it possible to pass the procedure call as a pass-throug query in an ADO (MDAC 2.7) recordset?

Thanks in Advance
Chris

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 14 2003

Added on Dec 6 2002

#oracle-provider-for-ole-db, #windows-and-net

1 comment

914 views