SQL & PL/SQL

Hi all,

I have one package.It contains many number of Procedures and Functions for different Schemas.
for Eg:

I have procedure defined in the package.This procedure created based on 10 columns. some 2 columns are hard coded like
item_seg_cd in ('675A','987B')

item_num in c_rec.item etc...

Now the requirement is :

I want to find out the O/P as

Procedure name :

Schema Name :

Column_name :


if I give these three values ,it should return the hard coded values of the given column

If the procedure doesn;t contain that column it should show teh O/P as " Given column is not available in this Procedure"

if the column i available in the procedure it should show the values defined for that particular column.

if column contains any hardcoded values it should ask

enter hard coded values :

enter New values :

update Hardcoded values with the given new values automatically.


SO could you please tell me is it possible to write any pl/sql program for this requirement.


Thanks.