Hi,
When am doing update in procedure through dynamically.It's getting the error.Can you please check whether it is correct or anything do it in a better way.
Procedure P1(u IN users%ROWTYPE,
r IN c1%ROWTYPE)
IS
BEGIN
sql_stmt := 'UPDATE users
SET
--------------------------
----------
----------
----------
-----
, email = NVL(r.email,u.email)
, firstname = NVL(r.firstname , u.firstname )
, lastname = NVL(r.lastname , u.lastname )
,'||AttribNameVar ||' = 'Root'
WHERE id = u.id';
EXECUTE IMMEDIATE sql_stmt;
END p1;
===============
Here AttribNameVar will come as columnName dynamically with another procedure.
suppose AttribNameVar = 'BH_INTEREST'(columnname in users table)
'CRD_INTEREST'
'CRD2_INTEREST'
and so on...
Can anybody help me why am getting error when i written this in dynamically.
Thanks in advance
Start Free Trial
