Stack Overflow
Stack Overflow

Questions tagged [dbms-crypto]

DBMS_CRYPTO provides an interface to encrypt and decrypt stored data, and can be used in conjunction with PL/SQL programs running network communications.

DBMS_CRYPTO provides an interface to encrypt and decrypt stored data, and can be used in conjunction with PL/SQL programs running network communications.

See http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_crypto.htm

31 questions
0
votes
1 answer

Procedure of updating_user throws error, when the parameter is null

I have next function, that hashes user password before inserting data in table: --/ CREATE OR REPLACE FUNCTION hash_password ( f_password IN CLOB ) RETURN RAW IS hash RAW(32); BEGIN hash := dbms_crypto.hash(f_password,…
Дмитрий Воликов
  • 3
  • 2
0
votes
1 answer

Storing encryption key outside Oracle database

My requirement is to do column level encryption. Tried below option TDE - data is not encrypted to one who has access to database. Please correct me if I'm wrong. DBMS_CRYPTO package, this works but client wants to store encryption key outside…
Var 2010
  • 1
0
votes
1 answer

Oracle PL/SQL produce the same hash as PERL crypt

My company is in the middle of migrating their old application (perl) into their new application (oracle apex). We currently have all of our internal processes up and running on oracle apex, while all of our merchants still use the old application.…
LogicallyFunky
  • 61
  • 1
  • 9
0
votes
0 answers

Best practice for Oracle DBMS_CRYPTO AES encryption

I'm tasked to create encryption/decryption methods inside an Oracle database. By researching I came up to this SO discussion which provides a great code example using the DBMS_CRYPTO package. However there is a security concern: in this design, the…
Cal
  • 747
  • 1
  • 13
  • 30
0
votes
1 answer

dbms_crypto and a Powershell

Can someone help me with code to encrypt a string in Oracle, and decrypt using powershell? AES, DES, either one will do. I feel like I'm close but am missing something... See also this post: Convert encryption / decryption function in PowerShell to…
criderkevin
  • 27
  • 1
  • 4
0
votes
1 answer

Using DBMS_CRYPTO.ENCRYPT safely - NLS error detected

I am trying to use DBMS_CRYPTO encrypt, but no matter how I choose some of the parameters, I encounter values for which the code throws ORA-01890: NLS error detected ORA-06512: at "SYS.UTL_I18N", line 72 ORA-06512: at "SYS.UTL_I18N", line 353…
Dantel35
  • 103
  • 1
  • 5
0
votes
0 answers

DBMS_CRYPTO to encrypt a numeric datatype

I have a requirement to encrypt NUMBER datatype in Oracle 19c. The requirement is to encrypt the data, and update the same to the column. After a while, if needed, the data has to be decrypted and provided to the customers. I found the DBMS_CRYPTO…
Anjana
  • 1
  • 4
0
votes
2 answers

ORA-24805:LOB type mismatch

Let there be table A(text_1 varchar2(4000 CHAR), text_2 varchar(4000 CHAR)) And here is the select for this: SELECT sys.dbms_crypto.hash(empty_clob() || text_1 || text_2, 2) from A; I am getting error 24805. I am expecting casting text_1 and…
Станислав Китаев
  • 147
  • 9
0
votes
1 answer

Error while using DBMS_CRYPTO function to decrypt CLOB data

I am tasked to do two Oracle functions which achieves the following: Take a CLOB as input and Encrypt it using AES-256 and return Encrypted CLOB Take the Encrypted CLOB as input, Decrypt it using AES-256 and return Decrypted CLOB The CLOB data is…
MAVERICK1985
  • 3
  • 3
0
votes
2 answers

Oracle dbms_crypto for PKCS7

My requirement is to peform the dbms_crypto tool to decrypt the encrypted column from a table which is encrypted from DOTNET end. It looks that PKCS7 method is used in dotnet where in I am unable to find corresponding padding in Oracle side; PKCS5…
ajmalmhd04
  • 2,582
  • 6
  • 23
  • 41
0
votes
1 answer

Oracle XE and DBMS_CRYPTO

is there no DBMS_CRYPTO package on Oracle XE databases? I searched the SYS user packages and all I could find was a DBMS_CRYPTO_TOOLKIT When I try to grant execute on DBMS_CRYPTO I get an error that the Table or View was not found. Is it stored…
monjo44
  • 31
  • 8
0
votes
1 answer

Lockbox 3 AES 128 Encrypt PLSQL dbms_crypto Decrypt

I am having trouble getting the same encrypted values returned between Delphi and Oracle any assistance would be greatly appreciated. It could possibly be the padding that might be causing the difference, unfortunately I am not sure. Lockbox…
Faadiel
  • 15
  • 4
0
votes
2 answers

dbms_crypto output mismatches with crypto-js

I'm working on creating an hmac-sha1 hash in Cerner's proprietary language, CCL. It's similar to PL/SQL and has access to native oracle functions. The idea is to mimic a hash created inside javascript. Oracle is using DBMS_CRYPTO and javascript is…
user1779418
  • 455
  • 1
  • 7
  • 22
0
votes
1 answer

How to transform a SQL record set in BLOB?

I am using an ORACLE database and I need to get the BLOB (or another LOB format) of a huge recordset (few thousands of rows), which I retrieve from a query. I need to populate the output format as a LOB to then provide it, as input to the…
GGG
  • 49
  • 1
  • 10
0
votes
1 answer

Loading an Oracle table with an encrypted LOB file and then decrypting it

I am being given a large encrypted file containing 10 million rows of data. I need to load this into an oracle database (in it's encrypted form) and then decrypt it in the database using pl/sql and the oracle built-in dbms_crypto. I then need to…
chief chest
  • 1
  • 1
1
2
3