Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Passing Table as Variable into Procedure
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? Received on Fri Aug 18 2006 - 16:05:25 CDT
![]() |
![]() |