PL/SQL (MOSC)

MOSC Banner

how to return multiple with oracle function or procedure

edited Jan 8, 2013 10:47PM in PL/SQL (MOSC) 31 commentsAnswered ✓
I wrote the below oracle function for encrypt some data...   but oracle function not able to return multiple at a time..  

how to fix this?

Thanks in advance.


CREATE OR REPLACE PACKAGE BODY enc_dec
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),

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center