Dynamic SQL and Update table question! [message #370478] |
Thu, 02 December 1999 01:42 |
Semenov
Messages: 6 Registered: December 1999
|
Junior Member |
|
|
Hello !
I have a problem when i try updating table using dbms_sql.It's not working and my table is not updating. The code is:
procedure tmp3(
ur1 varchar2:=null,
ur2 varchar2:=null,
ur3 varchar2:=null,
nammenu varchar2:=null,
dproc varchar2:=null,
locked varchar2:=null,
popup varchar2:=null)
is
cname integer; -- dbms_sql cursor name
rp integer; --rows processed
begin
cname:=dbms_sql.open_cursor;
dbms_sql.parse(cname,'update dispmenu
set nammenu=:nm,dproc=:dp, locked=:l, popup=:p where ur1=:u1 and ur2=:u2 and ur3=:u3',dbms_sql.native);
dbms_sql.bind_variable(cname, ':u1', ur1);
dbms_sql.bind_variable(cname, ':u2', ur2);
dbms_sql.bind_variable(cname, ':u3', ur3);
dbms_sql.bind_variable(cname, ':nm', nammenu);
dbms_sql.bind_variable(cname, ':dp', dproc);
dbms_sql.bind_variable(cname, ':l', locked);
dbms_sql.bind_variable(cname, ':p', popup);
rp := dbms_sql.execute(cname);
COMMIT;
dbms_sql.close_cursor(cname);
end;
Why it's not working?
Regards, D.Semenov
|
|
|
|