search

mortenbra / alexandria-plsql-utils

Oracle PL/SQL Utility Library
784 stars 317 forks source link

ZIP_UTIL_PKG Question/Errors #77

Closed IamActuallyLvL1 closed 3 years ago

IamActuallyLvL1 commented 3 years ago

Hello,

I am attempting to use the ZIP package to unzip a set of files. Whenever I call get_file I normally error out on line 250. This is because line 244 always returns 0 for tl_fl_ind.

https://github.com/mortenbra/alexandria-plsql-utils/blob/ada48755255df1be0bde6708adf243747c0000bd/ora/zip_util_pkg.pkb#L244

By getting to that point in the if's I am fairly confident in the blob and file_name inputs.

I tried a variety of different zip methods including a zip file that was created via this package. All of them returned tl_fl_ind of 0 and thus errored out in either the .copy at 250 or created corrupted blobs.

Is t_hd_ind + 42 the correct spot to find the tl_fl_ind?

This is not my strong suit so I apologize if I am missing something obvious or misinterpreted code.

Thanks,

Justin

IamActuallyLvL1 commented 3 years ago

Issue Fixed.

User error.

The blob I was passing in did not have the correct information. Editing the directory and file name before passing them into the function solved my issue.

Thank you