Home » SQL & PL/SQL » SQL & PL/SQL » ORA: 14551 : cannot perform a DML operation inside a query (merged) (oracle 10 g)
ORA: 14551 : cannot perform a DML operation inside a query (merged) [message #426435] Thu, 15 October 2009 08:10 Go to next message
saini006
Messages: 8
Registered: July 2008
Location: hyderabad
Junior Member
error while executing function.
This function is constructed to return a table type data.

ORA-14551: cannot perform a DML operation inside a query


can any one help me

thanks in advance

santosh
Re: ORA: 14551 : cannot perform a DML operation inside a query [message #426437 is a reply to message #426435] Thu, 15 October 2009 08:16 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I'm guessing that your function performs some sort of DML - Update, Insert, Delete.

Without seeing the function code, it's tricky to help more than that.
Re: ORA: 14551 : cannot perform a DML operation inside a query (merged) [message #426438 is a reply to message #426435] Thu, 15 October 2009 08:22 Go to previous message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-14551: cannot perform a DML operation inside a query
 *Cause:  DML operation like insert, update, delete or select-for-update
          cannot be performed inside a query or under a PDML slave.
 *Action: Ensure that the offending DML operation is not performed or
          use an autonomous transaction to perform the DML operation within
          the query or PDML slave.

Regards
Michel
Previous Topic: Update statement using 2 tables
Next Topic: ORA-06502
Goto Forum:
  


Current Time: Sat Oct 01 11:03:37 CDT 2016

Total time taken to generate the page: 0.09992 seconds