Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Locking in a F4.5 app based on a Views

Locking in a F4.5 app based on a Views

From: <Nilesh_at_cheerful.com>
Date: Thu, 04 Mar 1999 23:50:19 GMT
Message-ID: <7bn67p$c3e$1@nnrp1.dejanews.com>


I need to create an app based on a view.

I create a block with the base table set to the name of the view. I write all pl/sql code as i would in a normal form.

For my on-insert, on-udpate and on-delete trigger, I write code to do the respective dml on the base table blocks.

Do I need to use the On-lock trigger to change the default locking mechanism?

Is *any* change required at all wrt locking?

Regards, Nilesh Porwal

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 04 1999 - 17:50:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US