Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL: Passing TABLE NAME into module for SELECTs ???
I am trying to pass a table name into a module to be used
in the FROM clause....like below, this is NOT allowed, is it ?
What's the proper way ? DBMS_SQL ?
Thanks Jane
Procedure pass_this_junk ( v_tab_name IN VARCHAR2)
IS
v_count INTEGER;
BEGIN
SELECT count(*) INTO v_count FROM v_tab_name;
..................
END; Received on Wed Oct 24 2001 - 18:42:13 CDT