Hot answers tagged plscope
3
It looks like this is a bug with the handling of functions on collection variables. Given the following function:
create or replace procedure collection_functions as
type nested_tab is table of number;
var nested_tab;
num pls_integer;
boo boolean;
begin
var.extend(1);
var.trim(1);
var.delete;
boo := var.exists(1);
num := var.count;
end;
...
3
It is a bug, because the documentation states:
USAGE_CONTEXT_ID is a reflexive foreign key to USAGE_ID
UPDATE: A bit of troubleshooting...
all_identifiers.usage_id comes from sys.plscope_action$.action#
Given:
SQL> /
IDENTIFIER USAGE TYPE USAGE_ID USAGE_CONTEXT_ID LINE COL
------------ ----------- ------------------ ...
Only top voted, non community-wiki answers of a minimum length are eligible
