Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to encrypt and decrypt stored procedures and functions in oracle 9i

718029Aug 21 2009 — edited Sep 10 2012
hello every1 i want to encrypt the stored procedures and functions in oracle 9i as i dont want that any one is able to see or view the code

please can any one help me out and tel me the exact procedure of how to encrypt and again decrypt and is there any method that no one except the one who encrypts can decrypt the procedures and functions

Thanks & Regard
Pratik Lakhpatwala

Comments

628531
How many rows does the report return without the filter? If it's to high (100k?) then OBIEE will not add to the cache!

regards

John
http://obiee101.blogspot.com/
629048
Hi JOhn,

sorry for the reply, but the report without filter is big, but also tried with a smaller one. This is what i did. The report without filter has information from 12 departments. So i made a report with a filter for 2 department (where departmentno in (dep1,dep2))

When i try to open the report for one of these department it still doesn't get a cache hit.

Any other idea what i could do?

Osman
612229

Are you using any variables in your queries?

Mike

[http://www.biconsultinggroup.com]

629048
Hi Mike,

no there are no variables used in the query. The only thing is that there are column with a formula.

regards,

Osman
612229
If no variables are being used I've had mixed results when running a query for all of the records and then running a 2nd query that's a subset of the 1st query. The documentation states that OBI should used the cache entry created by the 1st query to produce the results for the 2nd query but this isn't always true.

Mike

http://www.biconsultinggroup.com
629048
OK, but is this a bug? Is there a workaround? The only thing what i will do for the time being is to make a the report for all departments seperate in the cache.

But if someone know how a sollution it would save me a lot of work. Now i need to do this for 1 report, but there will be more in the future.
612229
If you can always reproduce the bypassing of the cache then it would be great if you could open an SR on Metalink3. Also make sure that in your Answers request, the "Bypass Oracle BI Presentation Services Cache" checkbox is unchecked. A work around would be to tune the report to run within, say, 10 seconds so that even if a cache entry is not available that the report returns data quickly. Seeding cache is typically one of the last options in performance tuning.

Mike

http://www.biconsultinggroup.com
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 8 2012
Added on Aug 21 2009
23 comments
10,512 views