Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic Update Query

Re: Dynamic Update Query

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 23 Dec 1999 22:08:43 +0100
Message-ID: <945983389.12521.0.pluto.d4ee154e@news.demon.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US