This is a common requirement for DBA to export data from
production for various purposes. In a restricted & compliant environment
it’s a must to mask / scrub particular data while exporting from production.

Here’s a simple demonstration. I’ve got the hint from
metalink.

1. Create a
package to mask data

Note: The package needs to be created under the schema which
would be used to connect to datapump utility. I’ve used SYSTEM user for this
case.

Now the interesting part is Even though Oracle claims the wrapped code can't be unwrapped. But it does!!!There are couple of weblink where you can easily unwrap it. So the point of wrapping has become useless :(The following link is one of them.http://www.codecrete.net/UnwrapIt/