Home » Developer & Programmer » Application Express & MOD_PLSQL » DATA Entry form (Apex 4.2 version,windows 7)
DATA Entry form [message #596488] Mon, 23 September 2013 13:07 Go to next message
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.
Re: DATA Entry form [message #596535 is a reply to message #596488] Tue, 24 September 2013 07:22 Go to previous messageGo to next message
Littlefoot
Messages: 19677
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.
Re: DATA Entry form [message #596542 is a reply to message #596535] Tue, 24 September 2013 11:13 Go to previous messageGo to next message
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
Re: DATA Entry form [message #596561 is a reply to message #596542] Tue, 24 September 2013 13:33 Go to previous messageGo to next message
Littlefoot
Messages: 19677
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.
Re: DATA Entry form [message #596578 is a reply to message #596561] Tue, 24 September 2013 19:49 Go to previous message
rleishman
Messages: 3700
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
Previous Topic: Where to insert the validation for a textfield?
Next Topic: OS authentication in mod_plsql
Goto Forum:
  


Current Time: Mon Oct 20 05:38:30 CDT 2014

Total time taken to generate the page: 0.10784 seconds