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?

Thanks

asked 06 Nov '14, 06:24

AlfAbetas's gravatar image

AlfAbetas
611315
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

link

answered 06 Nov '14, 12:21

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
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

By RSS:

Answers

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

Tags:

×9

Asked: 06 Nov '14, 06:24

Seen: 2,156 times

Last updated: 06 Nov '14, 12:21


© Copyright Gerger 2017