Skip to Main Content

Java and JavaScript in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLJ is no longer supported anymore in Oracle 12.2 release the server-side

user5914526Jan 28 2020 — edited Jan 29 2020

Hi,

I found out that according to the Oracle Doc ID 2310077.1 Starting from Oracle 12.2 release the server-side SQLJ is no longer supported, and we have Java Stored Procedured compiled in Oracle Database and we are migrating the database to 12.2 version. This Java Procedure return the list of files from specific directory, and it is used by sereral others stored procedures actually.

Above similar question that a found in Ask Tom fórum, but the solution does't work to me:

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:9537288700346353520

But when I performed the SELECT above, informing someone specific directory name return ORA-00904: "UTIL"."LS": invalid identifier

select * from table(util.ls('YOUR_DIR_NAME'))

Does anyone knows how can help me ?

Regards,

Luciana Angeli

Comments
Post Details
Added on Jan 28 2020
1 comment
459 views