OraFAQ Forum: Forms » I have a problem with the view (merged by CM)

Home » Developer & Programmer » Forms » I have a problem with the view (merged by CM) (Forms 6i, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I have a problem with the view (merged by CM) [message #445583]

Tue, 02 March 2010 14:43

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!!!!

Report message to a moderator

Re: Help with insert or uptdate for view [message #445585 is a reply to message #445583]

Tue, 02 March 2010 14:55

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Help with insert or uptdate for view [message #445591 is a reply to message #445583]

Tue, 02 March 2010 15:45

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Can you issue updates against the view in sqlplus?

Report message to a moderator

Re: I have a problem with the view [message #445592 is a reply to message #445583]

Tue, 02 March 2010 15:46

Littlefoot
Messages: 21818
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.

Report message to a moderator

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

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

Report message to a moderator

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Sorry that I have been so long in replying. Have you solved your problem?

David

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:33:33 CDT 2024