Re: Table Name as Parameter to function.

From: Alla Gribov <alla.gribov_at_metatel.com>
Date: 27 Aug 1999 05:37:55 PDT
Message-ID: <37C694E1.FD852C45@metatel.com>

> You'll need to use the dbms_sql package to do this.
Not if you are using Oracle 8.x. They implemented a great think: EXECUTE IMMEDIATE. You don't need to use few of dbms_sql functions to open a cursor for the statement, bind variables, execute it and fetch results. Now, you can send you statement as a string to the EXECUTE IMMEDIATE.

Alla

>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> DavidP185 <davidp185_at_aol.com> wrote in message
> news:19990825203352.13283.00003349_at_ng-fh1.aol.com...
> > I've got a function that needs to work on several similar tables. All of
> the
> > field names and datatypes are the same. I was wondering it it would be
> > possible to pass the name of the table as a parameter and have the
> function
> > work for each of the separate tables.
Received on Fri Aug 27 1999 - 07:37:55 CDT