Sign in
Log inSign up
Haniel Burton

9 likes

·

1.2K reads

3 comments

Louis Moreaux
Louis Moreaux
Oct 12, 2022

Excellent post Haniel, thanks for sharing!

1
·
Plamen Mushkov
Plamen Mushkov
Oct 17, 2022

Great effort to build that view Haniel! Thanks for sharing!

I noticed it's not always possible to get the Profile, as apex_data_parser.get_file_profile is not available on apex.oracle.com for example (getting ORA-06502: PL/SQL: numeric or value error). Also the view couldn't compile for me (and couldn't run its statement) even on an environment I could read the file profile.

1
·
·1 reply
Haniel Burton
Haniel Burton
Author
·Oct 21, 2022

Hi Plamen, thanks for letting me know you were having issues with it. Let me test this weekend and get back to you.

I wonder why get_file_profile isn't available on apex.oracle.com.

·