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

Home -> Community -> Usenet -> c.d.o.server -> 40 Error Text = PLS-00201: identifier 'TABLE_NAME' must be declared

40 Error Text = PLS-00201: identifier 'TABLE_NAME' must be declared

From: <1517westmore_at_my-deja.com>
Date: Tue, 12 Sep 2000 23:56:31 GMT
Message-ID: <8pmfr5$riq$1@nnrp1.deja.com>

ok im a newbie here so bear with me :)

im trying to create a procedure to automate trigger/sequence creation. so far here is my code



procedure create_trigger
 ( table_name IN varchar2 )
IS
max_id_num number;
begin

   dbms_output.put_line('*** begining trigger creation');    select max(id) into max_id_num from table_name; /* max_id_num := select max(id) from table_name; */ end;

---

error that oracle spits back at me

Line # = 6 Column # = 40 Error Text = PLS-00201: identifier 'TABLE_NAME'
must be declared
Line # = 6 Column # = 4 Error Text = PL/SQL: SQL Statement ignored

im doing it exactly like pl/sql book says and i thought i _was_
declaring it at the top.

any light that anyone could shed would be very helpful.

thanks


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Sep 12 2000 - 18:56:31 CDT

Original text of this message

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