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
I have a G5 2.0 GHz dual processor. I bought it used, no history. I installed Leopard Family pack 10.5, I used the combo update to make it 10.5.8. I have a linksys router and a cable modem. Everything works fine program wise, but I can not hook up to [More]
I have a PDF from that I published to Acrobat.com There are fields to be filled out. Problems: 1. How can I set the fields to populate into an existing MS Access DB once submitted results back to me? 2. How can the form populate upon a certain chouic [More]
I've tried two UK PC Keyboards on my new mini. Both work fine apart from a few keys which are mapped incorrectly. The most annoying are that the @ (at sign) and " (double quotes) are the wrong way round. Is there a setting I can change (or some softw [More]
I am wondering if anyone else is having a problem with iTunes after updating to the latest version of Xcode from Mac app store.  Every time I open the app and try to modify a podcast I am subscribed to, I get the beachball and have to force quit the [More]
I'm trying to install the new version, but each time during the installation, "Error writing to file: C:/Program Files (x86)/Common Files/Apple/Mobile Device/Support/AppleMobileDeviceHelper.resources/Info.plist." Keeps popping up. What am I doin [More]
Hi, How Can I have word wrap in report based on delimiter in the column value For eg: My column value in country like AU:NZ , US:UK:CA I want the values to wrapped by delimiter ":" , so that ANZ and NZ comes in two line I tried REPLACE(country, [More]
Hi guys, I need help to implement XI BPM Scenario with Collect Messages Pattern. Here is my Scenario. I am getting four different types of flat files from four interfaces. Using these four files I need to merge using correlation relation and finally [More]
Hi guys- Forgive me if this is in the manual or in a thread, wasn't sure what to look up. I have a movie that contains clips A, B, and C. Step 1 is to make chapter markers for A, B, and C. Then, I would like to have, say, a chapter maker that would s [More]
I need help to set up AR_AUTOMNT process. I followed peoplebooks 'Setting Up Automatic Maintenance Processing' After i run the process in the message log i see this. 10 2:59:45PM PS:AR - Automatic Maintenance 10 2:59:46PM 1 Requests will be processed [More]
as aboceThank you Cor-el for your consideration. Unfortunately, although I might now need to look at the add-ons which you list, my posting relates to the fact that a member of the Mozilla team has raised a flag relating to a currently installed add- [More]