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!

declare custom type as %ROWTYPE variable in package

PRISMJun 6 2013 — edited Jun 6 2013

I am creating a bunch of custom RECORD types in a package specification like so:

CREATE OR REPLACE PACKAGE mypackage AS

TYPE t1 IS RECORD (a number, b number);
...

For consistency, I'd like to create a custom package type that uses a table %ROWTYPE, something like this:

TYPE t2 IS RECORD (table%ROWTYPE);

Is that possible in any way?

Tom

This post has been answered by bencol on Jun 6 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 4 2013

Added on Jun 6 2013

#11g, #plsql

4 comments

15,682 views