Home » RDBMS Server » Security » Encryption
Encryption [message #9285] Thu, 30 October 2003 12:37 Go to next message
Kelly
Messages: 9
Registered: January 2002
Junior Member
I'm trying to pull data back from a database that contains an encrypted field. When I run my query I keep getting the following error:

[[Oracle]][[ODBC]][[Ora]]ORA-28231: no data passed to obfuscation toolkit ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT_FFI", line 0 ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT", line 138 ORA-06512: at "SYS.TOOLKIT", line 26

Here is my query:

<cfquery name="GetAppln_id"datasource=#gs_datasource#>
Select password, Appln_id, toolkit.decrypt(Appl_Reserv)
from CSPEAPPL
Where password = '#session.password#'
and toolkit.decrypt(Appl_Reserv) = '#session.ssn#' </cfquery>

Does anyone see anything wrong with my SQL?
Thanks in advance for your help!
Re: Encryption [message #9286 is a reply to message #9285] Thu, 30 October 2003 13:01 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Does Appl_Reserv have a NOT NULL value?

It would help to see what your toolkit.decrypt routine looks like (which I assume is wrapper code for the Oracle encryption routines).
Previous Topic: system privileges and roles
Next Topic: Grant the rights to other database user
Goto Forum:
  


Current Time: Thu Mar 28 13:48:25 CDT 2024