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

Error compiling xutl_offcrypto.pkb #23

Closed aragorniiit closed 4 years ago

aragorniiit commented 4 years ago

I'm getting below error compiling xutl_offcrypto.pkb due to [Error] PLS-00201 (1319: 14): PLS-00201: identifier 'FILE2BLOB' must be declared. Please advise.

Thanks Kishore

mbleron commented 4 years ago

Looks like you had pulled the latest version of XUTL_OFFCRYPTO instead of the one bundled with ExcelTable. The latest version was bugged because I left a piece of testing code which lead to the above error. It is corrected now. Thanks for raising this issue.

aragorniiit commented 4 years ago

I actually compiled only pl/sql code, forgot the java installation steps. Let me try again after installation is complete.

On Tue, Jul 7, 2020 at 3:28 PM Marc Bleron notifications@github.com wrote:

Looks like you had pulled the latest version of XUTL_OFFCRYPTO instead of the one bundled with ExcelTable. That version was bugged, as I had left a piece of testing code which lead to the above error. It is corrected now. Thanks for raising this issue.

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/mbleron/ExcelTable/issues/23#issuecomment-655075816, or unsubscribe https://github.com/notifications/unsubscribe-auth/AHF2UB56FC5OVTTL3SHTD6LR2NZOZANCNFSM4OS4FHCA .