1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Insert function not working in Discoverer 10g

Discussion in 'Oracle Apps Technical' started by Ayan, Jun 30, 2010.

  1. Ayan

    Ayan Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    I have written a function in which some data is getting inserted into custom table, then some records getting updated. I have use Pragma autonomous_transaction also.
    I have registered the function in dico 10g. Then I create a workbook and trying to use that function in a calcualtion. Its returning "DML statement can not be executed".
    I have seen the same type of example in disco 4i. It is working there. Is it not possible in 10g?

    Please inform me asap about the cause and solution. If possible please send a mail to ayancd@gmail.com giving the solution.
    Thnx in advance.
     
  2. yknev

    yknev Active Member

    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    100
    Dear Aryan,

    As per my Knowledge, Is not possible to use DML and TCL commands in Functions. if possilbe, plz post your script.
    If u required to inserting or updating the data in table, you can u Procedures.

    Regards,

    Yknev.
     
  3. Ayan

    Ayan Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi Yknev, Can I register procedure in disco 10g?