Passing Table as Variable into Procedure

Giganews Newsgroups
Subject: Passing Table as Variable into Procedure
Posted by:  lydonberg…@gmail.com
Date: 18 Aug 2006

I'm new to PL/SQL from a .NET background.  I'm working on a procedure
to convert ISBN numbers to the new ISBN13 standard, and this needs to
be done on several (hundreds) of our tables.

I'm wondering if it's possible to setup a procedure that will accept a
table name (or table object, however you want to look at it) and column
name and will then take all of the values from table.column and run
them through a conversion function.  This way I will not have to create
what's practically the same procedure hundreds of times.

Is this even possible, and if so, can anyone shed some light on where
to start?

Replies