Skip to Main Content
Forums

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.

Update stored procedure?

657216Aug 29 2008 — edited Aug 29 2008
Hi there,

I'm a newbie about SQL/PLSQL, and I have a problem while working with Oracle. Can anyone help me to solve below problem?

I have a stored procedure as below:
PROCEDURE updateText(product IN VARCHAR2) IS+
BEGIN+

UPDATE table_name+
SET product_text = product;+
END updateText;+

which input params is:
* product: "product_code || product_description || product_name"
I want the new value to be a combination of "product_code || product_description || product_name" using value on the same record of updated record, and using appropriate value of that record.
However, when I run above stored procedure, the value of table_name.product_text became "product_code || product_description || product_name" for all records in the table :(.

Can you please help me on this? Thanks so much.

Regards,
Lam

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 26 2008
Added on Aug 29 2008
#procedure, #sql, #update
4 comments
322 views