|Subject:||Passing Table as Variable into Procedure|
|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