Current Position:Home > DML Operations in Stored Function

DML Operations in Stored Function

Update:11-30Source: network consolidation
Advertisement
Hi,
I have used Update Statement in a function. Which is giving an errror (ORA-14551: cannot perform a DML operation inside a query).
Can I use DML operations in a stored function ?
(I need help on locking master/transaction tables, i.e if a one user locks a master another user should not get modify access to the master/transactions).
Thanks
Ramesh Ganji

The Best Answer

Advertisement
Someone who obviously din't read my previous post in this thread. You should pay attention, programming is all about the details.
ORA-14551: cannot perform a DML operation inside a query).Then it obviously does more than just "returns a Table Type object". Why are you doing DML in a function?
PLS-00653: aggregate/table functions are not allowed in PL/SQL scopeWe can only call pipelined functions from SQL queries. So you'll have to ditch the DML or make it an autonomous transaction. Be very careful if you adopt the latter approach.
Cheers, APC
  • DML Operations in Stored Function Update:11-30

    Hi, I have used Update Statement in a function. Which is giving an errror (ORA-14551: cannot perform a DML operation inside a query). Can I use DML operations in a stored function ? (I need help on locking master/transaction tables, i.e if a one user

  • How to write DML operation in a function Update:11-30

    Hi Its very urgent for me. I am writing DML operation directly in a function and is being called from select statement, it is getting error as "DML Operations cannot be performed inside a query". How to write a DML operation inside a function. M

  • Get the Stored Function Results Update:11-30

    If there is DML in my Stored Function ,how to Using View Objects to Select Stored Function Results? I want to get the Stored Function Results in my jsp. please give me the example jsp.Thanks!There's an article on my "Dive into BC4J" weblog that

  • Any issue if we writing DML,DDL and TCL commands in stored functions. Update:11-30

    Hi, Is there any issue if we writing DML,DDL and TCL commands in stored function with help of PRAGMA AUTONOMOUS_TRANSACTION.Hi, Yes, Ofcourse. Using DML Statements Inside the function using PRAGMA AUTONOMOUS_TRANSACTION is not highly recommended. It

  • Executing DML-ing stored function from EntityManager Update:11-30

    Hi, Is there some way of getting the result from a DML-ing stored function from the EntityManager? I can use a native query and just select the function from dual if it doesn't do any DML but when it does, it is not permitted. I can't use getDelegate

  • Date Field Displaying and DML Operations Update:10-11

    Hi all, I have an issue with displaying and updating date columns that I'm hoping someone can assist me with. I'm using APEX 3.0.1. I have a Form page with a number of fields sourced from one database table that are being populated by an Automatic Ro

  • "cannot perform a DML operation inside a query" error when using table func Update:10-11

    hello please help me i created follow table function when i use it by "select * from table(customerRequest_list);" command i receive this error "cannot perform a DML operation inside a query" can you solve this problem? CREATE OR REPLA

  • Oracle 8i array DML operations with LOB objects Update:11-30

    Hi all, I have a question about Oracle 8i array DML operations with LOB objects, both CLOB and BLOB. With the following statement in mind: INSERT INTO TABLEX (COL1, COL2) VALUES (:1, :2) where COL1 is a NUMBER and COL2 is a BLOB, I want to use OCIs a

  • ORA-14551: cannot perform a DML operation inside a query Update:11-30

    I have a Java method which is deployed as a Oracle function. This Java method parses a huge XML & populates this data into a set of database tables. I have to call this Oracle function in a unix shell script using sqlplus. Value returned by this func

  • Recursing through table / complex return types in Java Stored Functions Update:11-30

    I have a table representing a tree with arbitrary depth, of the form: ID NUMBER(10) PRIMARY KEY, NAME VARCHAR2(20), PARENT NUMBER(10) with PARENT being a foreign key for ID, so that top-level nodes in the tree have a NULL PARENT, and other nodes have