Oracle中的动态SQL问题

create or replace  procedure GETFILE(TableName in VARCHAR2)
is
No_Rows Number :=0;
state varchar2(100);
begin
state :=\' select    count(*)  into   :p_id     from   \' || inTableName;
EXECUTE IMMEDIATE state using out NO_ROWS;

end;
end;

declare
begin
GETFILE(\'TABLE_NAME\');
end;

create or replace  procedure GETFILE(inTableName in VARCHAR2)
is
No_Rows Number :=0;
state varchar2(100);
begin
 state :=\' select    count(*)   from   \' || inTableName;
dbms_output.put_line(state);
EXECUTE IMMEDIATE state into NO_ROWS;
dbms_output.put_line(no_rows);
end;
/

declare
begin
getfile(\'dual\');
end;
/