PL/SQL (MOSC)

MOSC Banner

how can i avoid creating individual procedures which return data from different tables having differ

edited Jun 11, 2010 6:34PM in PL/SQL (MOSC) 13 commentsAnswered
 Hi,
thanks in advance for any kind of possible help.

i need a procedure which can pick table name at runtime, identify the structure and columns in that table and display the data for one particular row column wise. 

like below i created a procedure to get it from one table, i want to make it generic as i have to run this on 350 tables and that to periodically. one master table will give me info on what all tables i need to fetch for one particular record. it will give me classname and then i can map that classname to couple of tables and then this generic procedure need to display me data from all these tables. the data will be in the form of 'Column-name=data'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center