how to return multiple with oracle function or procedure
I wrote the below oracle function for encrypt some data... but oracle function not able to return multiple at a time..
CREATE OR REPLACE PACKAGE BODY enc_dec
how to fix this?
Thanks in advance.
AS
encryption_type PLS_INTEGER := DBMS_CRYPTO.ENCRYPT_DES
+ DBMS_CRYPTO.CHAIN_CBC
+ DBMS_CRYPTO.PAD_PKCS5;
encryption_key RAW (32) := UTL_RAW.cast_to_raw('MyEncryptionKey');
randomizer_key RAW (32) := UTL_RAW.cast_to_raw(randomizer);
FUNCTION encrypt (uname VARCHAR2, randomizer VARCHAR2, passwrd VARCHAR2) RETURN RAW DETERMINISTIC
IS
encrypted_uname RAW (2000);
encrypted_randomizer RAW (2000);
encrypted_passwrd RAW (2000);
BEGIN
encrypted_uname := DBMS_CRYPTO.ENCRYPT
(
src => UTL_RAW.CAST_TO_RAW (uname),
0