Home » Developer & Programmer » Forms » I have a problem with the view (merged by CM) (Forms 6i, Windows XP)
I have a problem with the view (merged by CM) [message #445583] Tue, 02 March 2010 14:43 Go to next message
MiguelFT
Messages: 6
Registered: February 2010
Junior Member
Hi all from Spain!!

I have a problem.

When i try insert or update in a view, the view say:

FRM-102: ORA-01732: DATA MANIPULATION OPERATION NOT LEGAL IN THIS VIEW.

I tried:

create_record in that view,

do insert in trigger "post-text-item" in the table of the view...

What can i do┬┐?

Can you help me??

How can i insert (or update) in a view?

Thanks!!!!
Re: Help with insert or uptdate for view [message #445585 is a reply to message #445583] Tue, 02 March 2010 14:55 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
a VIEW is simply a stored SQL (SELECT) statement.

You don't/shouldn't place a trigger on a SELECT statement.
You don't/shouldn't do DML against a SELECT statement.

CREATE TRIGGER on underlying table.
do DML against underlying table.
Re: Help with insert or uptdate for view [message #445591 is a reply to message #445583] Tue, 02 March 2010 15:45 Go to previous messageGo to next message
cookiemonster
Messages: 12420
Registered: September 2008
Location: Rainy Manchester
Senior Member
Can you issue updates against the view in sqlplus?
Re: I have a problem with the view [message #445592 is a reply to message #445583] Tue, 02 March 2010 15:46 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps you should read about INSTEAD OF triggers (created within the database). Also, check what's being said about Forms' ON-INSERT, ON-UPDATE, ON-DELETE and ON-LOCK triggers.
Re: I have a problem with the view (merged by CM) [message #445626 is a reply to message #445583] Wed, 03 March 2010 00:51 Go to previous messageGo to next message
sunil.madnani
Messages: 36
Registered: March 2007
Location: BHILAI
Member
Hi,

search for the instead of triggers.with the help of these triggers u can insert into the base tables from which the view is created.


Regards:
Sunil Madnani
Re: I have a problem with the view (merged by CM) [message #447397 is a reply to message #445626] Mon, 15 March 2010 01:06 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Sorry that I have been so long in replying. Have you solved your problem?

David
Previous Topic: how to get the date and time of file modification
Next Topic: PDE-PLI018 Could Not find Library
Goto Forum:
  


Current Time: Thu Dec 08 06:25:21 CST 2016

Total time taken to generate the page: 0.17341 seconds