Code to Update retrieved record in Oracle Forms 6i

5 pts.
Tags:
Oracle Database
Oracle development
Oracle Forms 6i
Retrieve Data Area
In Oracle Forms 6i, can anybody tell me about code to update data retrieved from database, which can be place under When Button Pressed trigger?

Software/Hardware used:
Forms 6i

Answer Wiki

Thanks. We'll let you know when a new response is added.

If the data was retrieved by a ‘database’ block, you just need to modify the values in the corresponding items (manually or by code). Then, to save the changes you have to call the COMMIT_FORM built-in procedure.

If it is not a database block, you have to execute an UPDATE (SQL) statement.

More details are needed to provide a better answer.

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Oracleform00
    i want to search a record from datbase in oracle 10g forms.
    10 pointsBadges:
    report
  • carlosdl
    That's great, Oracleform00. Let us know if you have any questions...
    70,220 pointsBadges:
    report
  • MelanieYarbrough
    Hi Oracleform00, If you have any questions, please ask a new question in the forum for easier search and answering. Please provide as many details as possible as well. Thank you! Melanie
    6,345 pointsBadges:
    report
  • Umairansari
    Dear,i have a datablock in which records are being fetched by a cursor.Records are being fetched properly.My question is i have hundereds of record in one fetch.When a new record insert into the table that cursor retrives all the record that is time consuming.I just want that new record should be fetched into the block where already records exists. Thanks awaiting for the answer if you could please Regards Ansari
    10 pointsBadges:
    report
  • carlosdl
    Hi Umairansari, To be able to provide an accurate answer we would need to know how those records are being fetched, and how the new record is being inserted. But you should create a new question, and provide more details. Also, please include some code.
    70,220 pointsBadges:
    report
  • RANANARESH
    you can update the data in oracle form by using ON_INSERT,ON_UPDATE ON_DELETE TRIGGERS. YOU WILL GET BETTER RESULTS.....PLS TRY IT ONCE ... 
    20 pointsBadges:
    report
  • RANANARESH
    HI FRIEND YOU WANT TO UPDATE THE DATA BY USING ORACLE FORMS. MY BEST SUGGESTION YOU WILL APPLY ON_INSERT,ON_UPDATE AND ON_DELETE  TRIGGERS ....YOU WILL GET BETTER RESULTS ...

    20 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following