Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 DBAReceived on Sun Apr 22 2007 - 10:21:23 CDT