OraFAQ Forum: Application Express, ORDS & MOD

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » DATA Entry form (Apex 4.2 version,windows 7)

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

DATA Entry form [message #596488]

Mon, 23 September 2013 13:07

lakshman0145
Messages: 12
Registered: May 2013
Location: HYDERABAD

Junior Member

I need to be able to insert data into multiple Tables by using a single form (artists, songs, albums, genres).
I have relational tables
(artist songs, album songs, song genres) that contain the ID of the relevant table.
How do I go about creating a trigger/sequence/function/package
to get the data from a form into the relevant tables automatically and so they all link up correctly.

Apologies about the Vagueness however I am stumped as to know where to start.

I am using Oracle XE as the Database, with Oracle Application Express as the front End application.

Any answers would be extremely Helpful.

Report message to a moderator

Re: DATA Entry form [message #596535 is a reply to message #596488]

Tue, 24 September 2013 07:22

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

One option is to create a view as a join of your tables. You'd then create a (tabular?) form on the top of that view. INSTEAD OF database trigger would be used to distribute data into every table.

Report message to a moderator

Re: DATA Entry form [message #596542 is a reply to message #596535]

Tue, 24 September 2013 11:13

lakshman0145
Messages: 12
Registered: May 2013
Location: HYDERABAD

Junior Member

hi,

I have tried but iam getting error it was
ORA-01776: cannot modify more than one base table through a join view
can u pls help

Report message to a moderator

Re: DATA Entry form [message #596561 is a reply to message #596542]

Tue, 24 September 2013 13:33

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What exactly did you try? Just don't say "what I was told", because that's not enough. You should provide as much information as possible, which includes tables' description, view definition, trigger code, and anything you find interesting and what could help someone of us assist you in what you are doing.

Report message to a moderator

Re: DATA Entry form [message #596578 is a reply to message #596561]

Tue, 24 September 2013 19:49

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

You would get that error if you created the view without the INSTEAD OF trigger.

Ross Leishman

Report message to a moderator

Previous Topic:	Where to insert the validation for a textfield?
Next Topic:	OS authentication in mod_plsql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 10:29:57 CST 2025