PLS-00762

I tried to use column level collation in my application, but my packages invalidated. The error code is PLS-00762.

The example below shows my problem.

Connected to Oracle Database 18c Standard Edition 2 Release 18.0.0.0.0

Connected as bgy@ctcm1

SQL> create table something(

  2  id integer not null,

  3  name varchar2(100)  collate generic_m_ai);

Table created

SQL> create or replace function get_something_rec( p_id something.id%type ) return something%rowtype as

  2  l_rec something%rowtype;

  3  begin

  4      select * into l_rec from something where id=p_id;

  5      return l_id;

  6  end;

  7  /

Warning: Function created with compilation errors

SQL> show error

Errors for FUNCTION BGY.GET_SOMETHING_REC: