Hello FS Team,

Question: how i must commit. If button event (from formspider application) call db procedure, that directly updating (deleting , inserting) and commiting records in DB (without datasource, like simpe update - update tab1 set col1=2 where col1=1; commit;), I must use pragma autonomous_transaction?


asked 06 Nov '14, 06:24

AlfAbetas's gravatar image

accept rate: 9%

Hi Alfabetas,

No, you can simply issue a regular commit. However, we recommend going through the model layer (datasources) as much as possible even though it is very tempting to issue direct DML.

Kind Regards, Yalim


answered 06 Nov '14, 12:21

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
accept rate: 15%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 06 Nov '14, 06:24

Seen: 2,423 times

Last updated: 06 Nov '14, 12:21

© Copyright Gerger 2017