Re: Passing Parameters

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 12 Jan 2001 20:14:02 +0100
Message-ID: <93nm1m$atl0q$2@ID-62141.news.dfncis.de>

You can overload the function

simply example without reference to records

procedure salary_increase (startdate in date); procedure salary_increase(startdate in varchar2);

Of course, using a package is mandatory.

Hth,

Sybrand Bakker, Oracle DBA

<art_merar5031_at_my-deja.com> wrote in message news:93njod$rgn$1_at_nnrp1.deja.com...
>
>
>
> I have a question about PL/SQL. I have a
> situation where I want to write a function that
> will be passed a record from a table. Normally I
> can code a %ROWTYPE within the fuction to define
> that record.
>
> However, I will be passing any of 10 different
> record definitions. Only one at a time, but it
> could be any one of ten. How can I do that?
> How can I create a generic %ROWTYPE or something
> to receive the record to the function?
>
> Please CC a copy to my e-mail:
>
> amerar_at_ci.chi.il.us
>
> Thanks,
>
> Arthur
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Jan 12 2001 - 13:14:02 CST