Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pass rowtype as function parameter, as a Object like type. How?

600198May 5 2008 — edited May 6 2008
Hi.

I have the following question.

I have 3 tables:
TAB1
TAB2
TAB3

I declare 3 rowtypes variables, one for each table:

v_tab1 TAB1%ROWTYPE;
v_tab2 TAB2%ROWTYPE;
v_tab3 TAB3%ROWTYPE;

I want to pass a rowtype as a function parameter, but i want the function to allow any rowtype to be passed as parameter, and then inside the function convert that "object" to the correct rowtype.

Is that possible?

In another language like C# for example, i would pass the rowtype as a object type, and then cast it to the correct data type.

I hope you can help me.

Cheers.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 3 2008
Added on May 5 2008
5 comments
1,961 views