---
title: "Comment by Plamen Mushkov on \"Stop Writing JSON_TABLE SQL Manually #JoelKallmanDay\" | Hashnode"
description: "Great effort to build that view Haniel! Thanks for sharing! I noticed it&#39;s not always possible to get the Profile, as apex_data_parser.get_file_profile is n"
url: "https://hashnode.com/posts/stop-writing-jsontable-sql-manually-joelkallmanday/63462382371493a162ee06e9/comment/634d8dda04eabc81632209d5"
---

[Discussion](https://hashnode.com/posts/stop-writing-jsontable-sql-manually-joelkallmanday/63462382371493a162ee06e9)

Comment [Stop Writing JSON\_TABLE SQL Manually #JoelKallmanDay](https://hashnode.com/posts/stop-writing-jsontable-sql-manually-joelkallmanday/63462382371493a162ee06e9)

[Plamen Mushkov](https://hashnode.com/@plamen9)

[Oct 17, 2022](https://hashnode.com/posts/stop-writing-jsontable-sql-manually-joelkallmanday/63462382371493a162ee06e9/comment/634d8dda04eabc81632209d5)

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.

[Haniel Burton](https://hashnode.com/@Haniel)

[Oct 21, 2022](https://hashnode.com/posts/stop-writing-jsontable-sql-manually-joelkallmanday/63462382371493a162ee06e9/comment/634d8dda04eabc81632209d5#reply-6352dd13ee1517c87af5fff8)

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.
