BI Publisher (MOSC)

MOSC Banner

Generating password protected file in Excel and MS Word format

in BI Publisher (MOSC) 1 commentAnswered ✓

Hi

We are on Oracle EBS 12.2.9

We have a requirement run a database query and produce an encrypted file that will hold confidential data and then email to our support team. We need a tool that is available in both unix and Windows.

The output would be a text file. I thought of using zip. But I have checked and found in our system zip password flag is not enabled, and 7z is not installed. So at this stage it is not possible to password protect a zip file and email to Support.

zip -P pas123 testzip q1.sql

zip error: Invalid command arguments (encryption not supported)

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center