Re: User-defined type in user-defined function

On 30 Sep 2004 06:19:48 -0700, uhcnam_at_hotmail.com (The Gooch) wrote:

>I am trying to create a function MYTEST.FUNC_UPDATECOORD which has, as
>one of its parameters, a variable of a type that's defined in the
>package MYTEST. This results in the error:
>
>ERROR at line 7:
>ORA-06550: line 7, column 32:
>PLS-00306: wrong number or types of arguments in call to
>'FUNC_UPDATECOORD'
>ORA-06550: line 7, column 21:
>PL/SQL: ORA-00904: "MYTEST"."FUNC_UPDATECOORD": invalid identifier
>ORA-06550: line 7, column 5:
>PL/SQL: SQL Statement ignored
>
>which you can see if you cut and paste the following code in SQL Plus.
>Is it possible to have such a parameter for a user-defined function?

Your actual parameter is varchar2, not of the UDT. Which is exactly what the error message is saying. Define the type in the package spec, and make sure the actual parameter is of this type.

--
Sybrand Bakker, Senior Oracle DBA