OraFAQ Forum: Forms » Problem on insert using a rowtype variable

Home » Developer & Programmer » Forms » Problem on insert using a rowtype variable (Pl-Sql/ Forms 6i)

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

Problem on insert using a rowtype variable [message #309721]

Fri, 28 March 2008 10:13

solisdeveloper
Messages: 48
Registered: March 2008
Location: Mexico

Member

Hi experts:

Well, this is my situation:
I'm currently working with Oracle Forms 6i and in my form i select the current information of a given user, let's say the user with ID 16. I do it using a rowtype variable named rt_info, it looks like this:

SELECT * INTO rt_info FROM users WHERE ID = 16;

Then i change some values for example the city, and I asign a new number of ID. It looks like this

rt_info.city := 'NEW YORK';
rt_info.ID := 17;

And then i simply insert the new record

INSERT INTO users VALUES rt_info;

The PROBLEM is that after I insert the new record with the ID number 17, suddenly the record with the ID 16 has sufered changes, It also says NEW york in the field city, but I never executed any update statement.

Anybody has an idea of why is this happening?
Thanks in advance.
Regards!

Report message to a moderator