0

I am using Oracle SQL Developer on MacOS and I am trying to save zip file into Blob field. I know how to load any other file type by clicking "Load" button and then selecting the file.

enter image description here

The problem is that when I select the zip file and click on Open, it does not select that file, but shows the me the content of zip file and then I can select only one file from that zip. This is not what I want, because I want to upload the whole zip.

Is there any setting in Oracle SQL Developer or any other way?

I do not have such problem on same table when using PLSQL Developer on Windows machine.

Improve this question
0

1 Answer 1

Reset to default
1

I have found out that when I have a zip file in a folder, then Oracle Sql Developer automatically shows also folders for this file, even if does not exist in reality on disk. The name of the folder and the file is the same including extension. Different is only the icon. If you select archive then loading to blob works ok. This is the behaviour on MacOS. I did not test it on other systems. On bottom picture is the example of folder containing only 2 zip files and how it looks when you try selecting file from that folder.

enter image description here

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Nice! I totally overlooked this. Thanks for figuring this out and sharing.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.