Technology Stack - EBS (MOSC)

MOSC Banner

Update or insert in View(which is a combination of tables)

edited Aug 20, 2021 11:05AM in Technology Stack - EBS (MOSC) 1 commentAnswered

(I am new in oracle form or report and even in IT. Thank for your help first ^^)

I am creating a form which is a master - detail form. In the master, for example, "Sport" is shown. Then, in detail part, some sport should come up like "football", "basketball" etc.

The way I am using is just use the data wizard and create a relationship between them. This way is OK for just SELECT but not work in INSERT or UPDATE.

And one of my AP said, it should be make use of temp data block to save the detail record, and read all the detail filed and make use of API or procedure to INSERT and UPDATE.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center