Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 40 Error Text = PLS-00201: identifier 'TABLE_NAME' must be declared
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
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