Home » SQL & PL/SQL » SQL & PL/SQL » File compressing is not happening (Oracle 11g , 11.2.0.3.0)
File compressing is not happening [message #665102] Tue, 22 August 2017 00:59 Go to next message
mm_kanish05
Messages: 488
Registered: January 2007
Location: Chennai
Senior Member

Hi all,

I have created a java source for compressing activity.

The flow, a normal file is getting generated using UTLFILE. The file is getting generated successfully in specified directory but the compressing is not happening. The following line will prepare the zip file.

UTLZip.compressFile('PersonAccrualDetail.DAT','PersonAccrualDetail.zip');

help me on the issue.

Regards,
Muthu
Re: File compressing is not happening [message #665104 is a reply to message #665102] Tue, 22 August 2017 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 65973
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

UTLZIP is NOT an Oracle standard package.
So this question bears no real connection with Oracle database.
Please find a more appropriate forum or ask your provider.
The topic is locked. /forum/fa/448/0/
If I'm wrong, please, PM me (or report this message to a moderator, explain why you think it should be unlocked and it might be done).

Re: File compressing is not happening [message #665113 is a reply to message #665104] Tue, 22 August 2017 03:43 Go to previous message
cookiemonster
Messages: 13339
Registered: September 2008
Location: Rainy Manchester
Senior Member
Since UTLZip doesn't have a directory parameter I imagine you need to include the full path in the file name parameters.
Previous Topic: Max function
Next Topic: Using Trigger in Oracle DB to update a table in SQL Server DB
Goto Forum:
  


Current Time: Mon Nov 19 01:51:36 CST 2018