Re: Coding Question about user-defined types as parameters

On Sun, 22 Apr 2007 00:46:39 GMT, "Dereck L. Dietz" <dietzdl_at_ameritech.net> wrote:

>ike this?:
>
>SUBTYPE the_type cr_cursor%ROWTYPE;
>
>And that will allow
>
>PROCEDURE test(p_parameter IN the_type)
>
>to compile?

At least it works when defined in a package spec and using <table_name>%rowtype.

<cursor>%rowtype probably isn't any different.

-- 
Sybrand Bakker
Senior Oracle DBA