why this table x$krbmsft not working in 19c.?
Hi Team,
below query is working fine in APPS instance like development instance. but not working in non-apps instance like SIT,UAT and prod.
SELECT file_name FROM
TABLE ( file_pkg.get_file_list(file_pkg.get_file('directory_path') ) ) all_files
WHERE all_files.is_dir = 'N' ORDER BY 1;
so i got alternate for the same. that is below query. and below query is having this table : - x$krbmsft
but getting this table or view does not exist ORA-00942
Create the function as SYS;
CREATE OR REPLACE FUNCTION xx_list_files (
lp_string IN VARCHAR2 DEFAULT NULL
) RETURN xx_file_array