PL/SQL (MOSC)

MOSC Banner

utl_compress.lz_compress removes file extension after compression

in PL/SQL (MOSC) 9 commentsAnswered

I am using database 19c (19.10.0.0.0) I have a requirement to compress file in a directory. File exists in directory with name ST300421.txt I want to compress it with name ST300421.zip

Compress is done successfully but file extension is removed for example inside ST300421.zip file ST300421 exists (without extension .txt) which use less for program to read and proceed further. Refer attached code which I am using.



Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center