search

mbleron / ExcelTable

ExcelTable is an Oracle SQL interface to read Microsoft Excel files (.xlsx, .xlsm, .xlsb, .xls, .xml), ODF spreadsheet files (.ods) and flat files as external tables
MIT License
45 stars 12 forks source link

It doesn't work for Oracle 12c #10

Closed lkvn01 closed 5 years ago

lkvn01 commented 5 years ago

Under Oracle 12c generates error during creating jar exceldbtools-1.6.jar

Error while creating jar java/lib/sjsxp-1.0.2.jar ORA-06550:... 25: PLS-00302 component 'FINISH_LOADING_JAR' must be declared

mbleron commented 5 years ago

Error while creating jar java/lib/sjsxp-1.0.2.jar

If you're on Oracle 12 then you must NOT load sjsxp-1.0.2.jar. It's clearly explained in the README.

About the actual error :

PLS-00302 component 'FINISH_LOADING_JAR' must be declared

That's because you're not using the correct version of the loadjava utility. You need loadjava from a 12c client.

mbleron commented 5 years ago

Closing this (installation issue).