Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Passing Table as Variable into Procedure

Passing Table as Variable into Procedure

From: <lydonbergin_at_gmail.com>
Date: 18 Aug 2006 14:05:25 -0700
Message-ID: <1155935125.471739.298090@p79g2000cwp.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US