use execute immediate.
Jim
"TurkBear" <jgreco1_at_mn.rr.com> wrote in message
news:1f6f1u4jigtf1dh6n5in3lcliv6mq0lbhp_at_4ax.com...
> I want to dynamically specify a column and its value to update with by
calling a Pl/Sql proc ..
> The code ( a very simple test) is
> CREATE OR REPLACE Procedure TEST_PLUPDATE (clname varchar2 ,val1 varchar2)
IS
> begin
> update test_plup
> set clname = val1;
> end;
>
> It will not compile since clname is not, at compile time, a column name in
test_plup..
>
> How can I design a proc that will accept a column name and a value and use
those to update the table?
>
> Thanks
> *( Oracle 8.1.6)
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> Check out our new Unlimited Server. No Download or Time Limits!
> -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
Received on Wed Dec 12 2001 - 12:51:31 CST
