Skip to Main Content

anytype error

naveenmani912Mar 25 2019 — edited Mar 26 2019

Oracle DB : 10g

I have the following function which gives me error when i am compiling.

function get_anytype_members_info( a_anytype anytype )

    return t_anytype_members_rec is

    l_result  t_anytype_members_rec;

  begin

    if a_anytype is not null then

      l_result.type_code := a_anytype.getinfo(

        prec        => l_result.precision,

        scale       => l_result.scale,

        len         => l_result.length,

        csid        => l_result.char_set_id,

        csfrm       => l_result.char_set_frm,

        schema_name => l_result.schema_name,

        type_name   => l_result.type_name,

        version     => l_result.version,

        numelems    => l_result.elements_count

        );

      end if;

    return l_result;

  end;

getting the Following Error:

[Error] PLS-00306 (234: 29): PLS-00306: wrong number or types of arguments in call to 'GETINFO'

Comments
Post Details
Added on Mar 25 2019
7 comments
130 views