Re: Dynamic Update

You need to do dynamic sql if you're creating the query on the fly. Easier in 8i than 8, still possible in 7.3.4.

Look at the Application Developer's Guide for the version of Oracle you're running at http://technet.oracle.com/docs/products/. ----- Original Message -----
From: David Barbour <DBarbour_at_connectsouth.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Sunday, October 22, 2000 12:21 PM
Subject: Dynamic Update

> Hi,
>
> I'm trying to update a record in a table when it's selected. There are a
> series of tables from which records are obtained, and I've successfully
> written the PL/SQL that gets among other things the table name and the rowid
> for the record. Now I need to update a status field.
>
> The variables are:
> table_name = v_table
> rowid = whichrow
> v_status:='GOT'
>
> The following statement won't work: Update table ||v_table|| set ld_status
> = v_status where rowid = whichrow;
>
> I get the following error:
> PLS-00103: Encountered the symbol "|" when expecting one of the
> following:
> (
> I've tried a variety of combinations of single quotes and concatenation, but
> so far, no success. Any ideas?
>
> David A. Barbour
> Oracle DBA - ConnectSouth
> 512-681-9438
> dbarbour_at_connectsouth.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: David Barbour
> INET: DBarbour_at_connectsouth.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Sun Oct 22 2000 - 12:54:35 CDT