Re: Dynamic Update Query

you need to use the dbms_sql package to do this. basically
build a string
cur_handle := dbms_sql.open_cursor;
dbms_sql.parse(cur_handle, sqlstr, dbms_sql.native); res := dbms_sql.execute(cur_handle);

Hth,

--
Sybrand Bakker, Oracle DBA
Destyn Stringham <dstringham_at_comcenters.com> wrote in message news:83u1lb$d4q$1_at_news.xmission.com...
> I am trying to do a dynamic update procedure that has the following
> arguments passed in.
>
> FieldName
> Value
>
> I want the update to dynamically updated the specified field with the
value
> passed in.
>
> I am receiving the following error:
> ORA-01747: invalid user.table.column, table.column, or column
specification
>
>
> Does anyone have a way to do this in Oracle?
>
> Thanks
> DS
>
>
Received on Thu Dec 23 1999 - 15:08:43 CST