Home » SQL & PL/SQL » SQL & PL/SQL » update a row in a view
update a row in a view [message #39850] Fri, 16 August 2002 13:12 Go to next message
mike glinski
Messages: 1
Registered: August 2002
Junior Member
Does anyone know how I can update a row in a table using a view?

I have a view which is calling a function that calls a procedure which, based upon the result of a field search, updates a tables field with new data.

Using an execute statement in pl/sql, everything works just peachy, however, I need to have this done when the procedure is called by a function, which in turn is invoked by a view.

OUCH!!!!

Report message to a moderator

Re: update a row in a view [message #39858 is a reply to message #39850] Mon, 19 August 2002 05:05 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
By default, the table is updated, if u update the view.
( unless you define the view with check options)

Report message to a moderator

Previous Topic: Looping in PL/SQL
Next Topic: Triggers
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 17:30:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.