Re: plsql err

table name cannot be aused in such way i.e. as bind variable.
Here is link I'v already sent privately, but it seems it would'n hurt
also to public :)
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:227413938857

here is also code snippet:

00:10:57 gints@> create table a1(a number);

Table created.

Elapsed: 00:00:00.07
00:11:19 gints@> declare
00:11:42   2    tb varchar2(2) := 'a1';
00:11:42   3    nm number := 1;
00:11:42   4  begin
00:11:42   5    execute immediate 'insert into :a values (:b)' using tb, nm;
00:11:42   6  end;
00:11:43   7  /
declare
*
ERROR at line 1:
ORA-00903: invalid table name
ORA-06512: at line 5


Elapsed: 00:00:00.01
00:11:44 gints@> ed
Wrote file afiedt.buf

  1  declare
  2    tb varchar2(2) := 'a1';
  3    nm number := 1;
  4  begin
  5    execute immediate 'insert into a1 values (:b)' using nm;
  6* end;
00:11:59 gints@> /

PL/SQL procedure successfully completed.


Gints


On 1/24/06, GovindanK <gkatteri@xxxxxxxxxxx> wrote:
> You would generate sql commands on the fly ; Subsequently you can do
> either of the following:
> 1. Either spool them out and run them separately
> 2. Store them in a varchar2 variable and execute the string
> 3. Execute immediate .. update :tname set :cname = :value using parm1 ,
> parm2 , parm3.
>
> HTH
>
> GovindanK
> Certified DBA
>
--
http://www.freelists.org/webpage/oracle-l


Other related posts: