Dear Team,

I want to create procedure, in which i input table name part1 because it
will change according my condition and table_part2 is always fixed. i
marked in bold what i want to say

CREATE OR REPLACE procedure pname(table_part1 varchar2) as
a table_part1+table_part2.aa%TYPE;


example

CREATE OR REPLACE procedure pname(hello varchar2) as
a hellotable.aa%TYPE;

CREATE OR REPLACE procedure pname(bye varchar2) as
a byetable.aa%TYPE;


please send the syntax


Thanks & regards,

Sudhanshu Shekhar
IBM India Pvt. Ltd.
+91 99370 02535
[Email address protected]


Oracle LazyDBA home page