hi all,
can anyone give me some suggestion s HOW TO PASS TABLE NAME AS A PARAMETER to procedure...
i vil show some example .....

Code:
Create a procedure that takes table name and column names as parameter and displays data.
this is my question...
i tried something but am getting error...so anyone help me...my code is...
Code:
create or replace
PROCEDURE TO_CALL_TABLE
( TABLENAME IN varchar,E_NAME OUT EMP.ENAME%TYPE,E_NO IN EMP.EMPNO%TYPE) is
BEGIN
SELECT ENAME INTO E_NAME FROM tablename
where empno=e_no;
END;