| Encryption [message #9285] |
Thu, 30 October 2003 12:37  |
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  |
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).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
