Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Insert into the same table with the new column values

626653Sep 17 2009 — edited Sep 17 2009
Hi,

I like to insert into the same table with the with new effective date and new value for one column.
For Instance:

If table ABC contains columsn UNIT
,UNION
,EFFDT
,PLAN
,GRADE
,STEP )
Il need to insert new values for UNIT and EFFDT but the remaining values could be same for columns PLAN, GRADE, STEP. I like to have a statement to select the colums from the same table and insert into the same table. Please let me know how to write sql statement for oracle.
Thanks in advance.

Comments

jmarc
in older apex version,
the error was "Error in mru internal routine: ORA-20001: Error in MRU: row= 1, ORA-20001: ORA-20001: Current version of data in database has changed since user initiated update process" .


the message is now more elegant
but i'm the only one on this sample and i have the message each time a validation fails .


any help would be very appreciate.
jmarc
i can reproduce the problem on apex.oracle.com
for the sample tabular form,

if i change in globalization the Application Primary Language from english(en) to French(France) fr .
975525
Hello there,

I've got the same issue here, do you have any update?

Apex 4.2, Application Primary Language set to French (Canada)(fr-ca).

In my case I've done some test and here is what I've found:

In a Tabular Form with a numeric field, if there is a value with a comma (ex: 12,5) in it, any validation who triggers on any other field will cause the error "Current tabular form data is too old".
If all the numerics are whole numbers, no problem.
Also, if I change the Application Primary Language to English (United States)(en-us) everything is fine.

Same thing whith a date field, if there is a date in the field, if a validation fires, same error message. If I specify a Date Format or If I set the Application Primary Language to English (United States)(en-us) everything is fine again.

I've got the same behavior on apex.oracle.com.

Regards,
Lucien
975525
Our Apex version is 4.2.0.00.28.
Regards,
Lucien
jmarc
i have opened a SR on metalink

it's a bug # 15851176.

BUG 15851176 - TABULAR FORM ADD ROW BROKEN WHEN PRIME LANG NOT ENGLISH


fixed in 4.2.1


regards
975525
Thanks JM for the update.
Regards,
Lucien
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 15 2009
Added on Sep 17 2009
12 comments
11,466 views