OraFAQ Forum: SQL & PL/SQL » ORA: 14551 : cannot perform a DML operation inside a query (merged)

Home » SQL & PL/SQL » SQL & PL/SQL » ORA: 14551 : cannot perform a DML operation inside a query (merged) (oracle 10 g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA: 14551 : cannot perform a DML operation inside a query (merged) [message #426435]

Thu, 15 October 2009 08:10

saini006
Messages: 9
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

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Update statement using 2 tables
Next Topic:	ORA-06502

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 01:07:07 CST 2024