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: 493
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: 68625
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: 13917
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: Fri Mar 29 06:46:13 CDT 2024