First off, I'm an MSSQL developer, so my apologies of I'm off on some of the terminology or basic understanding of this this works :)
I've been asked to extract some data from an Oracle database, but one of the columns I need is encrypted with a certificate. I received a Java class from the vendor that decrypts and writes the data to a file, but I want it returned inline, in my result set. Essentially, I want to do this:
SELECT MyKey, SomeValue1, SomeValue2, decryptThisValue(SomeEncryptedValue) as DecryptedValue
I have successfully used loadjava to load their library and map it to a function in Oracle, but it's doesn't do what I want - I can call the function, and it will successfully decrypt my value and write it to disk, but I want it returned as part of the query results. It's my understanding that the "main" in a java class always has to return "void", so I'm stuck here about how to get my value out.
In .Net/MSSQL, I can set the return type of my function call to whatever I want, so I can return the value as a bytestream or Base64 string or whatever, and I'm looking to do the same thing in java/Oracle. Any help is appreciated, and again, I apologize if I'm missing something really obvious here.