Sitemap

Amicuk Programming Answers

Encrypt procedure

-0001-11-30   Views:0

Advertisement

I, wanted to know that how, can we encrypt a procedure in Oracle. As, per my knowledge, this is generally done so that unwanted people cannot read the code of the procedure. I hope, my question is clear. Please, help in solving the doubt. regardsuser

I, wanted to know that how, can we encrypt a procedure in Oracle. As, per my knowledge, this is generally done so that unwanted people cannot read the code of the procedure.
I hope, my question is clear.
Please, help in solving the doubt.
regards

The replay answer
Advertisement
user574290 wrote:
hi,
thanks, for your answer. But, this talks more of encryting pl/sql code in a file. I wanted to see this encrytion when I access the procedure from TOAD. I think, it is possible.
I hope, my question is clear.
Please, help in solving the doubt.If you actually read about "wrap" it encrypts your source file code. You then run that encrypted source file code against the database, just as you would if it were not wrapped, and then the code stored on the database also becomes encrypted. It's very simple and, by now, you could have tried it to see for yourself.

Go to See the other 9 answers

Encrypt procedure in oracle

Category:DefaultRelease time:-0001-11-30Views:130

How to encrypt the procedure in oracle use wrap? Pls tell me the way and step.check this dude: http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/c_wrap.htm#2062 succes.Read other 2 answers[More]

Encrypt procedure

Category:DefaultRelease time:-0001-11-30Views:130

I, wanted to know that how, can we encrypt a procedure in Oracle. As, per my knowledge, this is generally done so that unwanted people cannot read the code of the procedure. I hope, my question is clear. Please, help in solving the doubt. regardsuser[More]

Third part encryption procedure

Category:DefaultRelease time:-0001-11-30Views:130

Is there a third party (from an Oracle partner) procedure to encrypt data with a 128 bits key algorithm?.Is there a third party (from an Oracle partner) procedure to encrypt data with a 128 bits key algorithm?.Read other 4 answers[More]

Get error message from a nested/encrypted stored procedure

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have an encrypted procedure, that is used inside my 'own' complex procedure as: Begin try Begin tran Do a lot insert into #tmp exec xp_encryptedSP Do a lot more commit tran end try begin catch print ERROR_MESSAGE() rollback tran end catch Some[More]

AES encrypt/decrypt

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I need to encrypt a file in Java using AES, given an 'EncryptionKey'. The "EncryptionKey" will be given to me as a String. Later, the client needs to be able to decrypt it using the same "EncryptionKey", with ANY decryption tool. I[More]

Encrypting data and using a funtion

Category:DefaultRelease time:-0001-11-30Views:130

I am using dbms_obfuscation_toolkit.DESEncrypt This is a procedure. so if i need to encrypt data, I have to do it row by row. I actually need to update records to make them encrypted so its cursor run encrypt procedure update this is really slow. any[More]

How to cancel filevault encryption process midway, since it is demanding 12 hours

Category:DefaultRelease time:-0001-11-30Views:130

After upgrading to OS-X Yosemite version 10.10, I enabled filevault encryption option. Since then whenever I connect to the electric power, the disk starts encrypting procedure. I try to turn it off, it says to wait until the file encryption complete[More]

IS Transperent Data Encryption is secure from DBA?

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, I want to encrypt some of data, for that i learn about Transperent Data Encryption, But i have doubt that TDE cant able to provide security against DBA. I want your valluable comment on this. and I want to know, is there any other way to secu[More]

Administrator Password Change

Category:DefaultRelease time:2015-10-11Views:130

Hi, After changing the default Administrator Password in the RPD, I ran the Cryptotools utility for both BI publisher and BI Scheduler to make sure that the BI Presentation services can identify the CredentialStore. There is another xml file, xmlp-se[More]

Oracle upgrade problem from 8.1.6.2.0 to 9.2.0.3.0

Category:DefaultRelease time:2015-10-11Views:130

We have upgraded our database to version 9.2.0.3.0 from version 8.1.6.2.0. Everything is fine accept a proprietory encryption package that utilises the UTL_RAW package and stores working variables in a PL/SQL Record structure consisting of 6 RAW(4) f[More]

DBMS_CRYPTO error

Category:DefaultRelease time:-0001-11-30Views:130

Hi I have problem using dbms_crypto package. If I execute this code: declare   c_text clob := to_clob('TEST TEXT');   b_result blob;   function crypt (ac_text clob) return blob as      secret_key   RAW (32) := utl_raw.cast_to_raw('1234567890123456789[More]

Hot
Please help! I recieved my iPod in September 2005. It has been working perfectly fine until this month. I've been trying to add more songs to my iPod. I connected my shuffle to the USB port, and all I am recieving is my iPod blinking orange. I have t [More]
Hi, experts,      I have four solutions in which I added one extension field to a standard BO.      Let's say they are S1,S2,S3 and S4 respectively and all are of the same data type.      I added each of them to the Advanced Find Form of the standard [More]
In the CD view, it would be really handy if there was a way to play a CD list as if it were an actual CD. In other words, add a set of transport controls to CD view. This would allow you to audit track order, track-to-track silence, volume, etc. with [More]
How do I convert my DVD to WMV?TopoTone wrote: Flip4Mac is the best thing for this, but, you can't get it done with the version OS software you have. Requires at least 10.3.9 OS. Ah, good catch. An ancient 733 macintosh running system 9+ is not a via [More]
Hi We have started using several PJCs to enhance our 10g webforms. The conversion has not gone live and I need to decide how to deploy the PJCs. The 2 options that I can think of: 1. Have all PJCs packaged into one jar. Pro - no need to change formsw [More]
Hi everyone, I have the following system: PCI-7330 UMI-7764 four P7000 series drivers four Nema 23 stepper motors, each with an encoder In max, I can operate each moter fine while in open-loop mode, but as soon as I try to operate any of the motors i [More]
When I try to open the installer.app, I get the message: "You cannot open the application Adobe AIR installer.app because it is not supported on this architecture".  I am running OS 10.5.8 on an iBook G4 (1.42 GHz PowerPC G4).  Help, please.  I [More]
can i start one weblogic server that listening on several port, one for different application? for example, 7001 for general user, and 7005 for admistrators and ask for two way authentification? can i do this? or do i have to start two weblogic insta [More]
I live in a college dorm and i have been using internet sharing through an ethernet cable to connect to xbox live and it has been working fine for months now, but has now recently decided to make everything difficult and it continuously just says sel [More]
I've just gotten a new laptop and noticed the same issue I had with my previous laptop. On my old laptop I installed Visual Studio 2013 and MSSQL Server 2012 Web Edition. When I use SSMS to connect to a remote database (also 2012 Web Edition) Intelli [More]