Hi all,
I'm on APEX 24.2.2.
We're using (and liking!) the new Database Object Dependencies in APEX. It gives us a lot of insight into the use of objects in our application! We use it to reguarly check if there are errors in object references.
However, there is one type of error in the Errors node, that is not really an error: When there is an ‘Invoke API’ process, that invokes a procedure of which a parameter is of a user defined type. For example:
create or replace type number_tab as
table of number
/
create or replace procedure test_number_tab(p_number_tab in number_tab)
as
begin
if p_number_tab is not null and p_number_tab.count > 0
then
for i in 1 .. p_number_tab.count
loop
dbms_output.put_line(p_number_tab(i));
end loop;
end if;
end test_number_tab;
/
If I make an Invoke API process, and populate the parameter like this:
This process works. However, in the Database Object Depencencies, there is an error:
Am I doing something wrong in defining the parameter? Or is there a problem with user defined data types in this report?