Oracle Error 28817
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Oracle Application Express (APEX) All PlacesDatabaseDatabase Application DevelopmentOracle Application Express (APEX) This discussion is archived 4 Replies Latest reply on Feb 22, 2013 11:55 AM by Dan256 ORA 28817 PLSQL function returned an error . when Access instance apex 4 2 fatehcis-JavaNet Oct 17, 2012 6:58 AM Hello, I have just upgraded from apex 4.1 to apex 4.2. Everything is fine except for this error that I get when I try to access Instance Setting on the Admin App (localhost/apex/apex_admin) ORA-28817: PL/SQL function returned an errorWhat could be the problem ?? How can we fix it .. I am working on Win server 2012 machine .. apex 4.2 with apex listener 2 deployed on Glassfish 3.1.2. Best Regards, Fateh 4240Views Tags: none (add) apex_42Content tagged with apex_42, intance_settingsContent tagged with intance_settings This content has been marked as final. Show 4 replies 1. Re: ORA 28817 PLSQL function returned an error . when Access instance apex 4 2 Christian Neumueller-Oracle Oct 17, 2012 9:12 AM (in response to fatehcis-JavaNet) Hello Fateh, we are already aware of that problem, although it is not yet present on our Known Issues webpage. The reason for this error is that the new installation overwrites an instance-wide encryption key. Values in the instance preferences that were encrypted with the old value (the SMTP password and the wallet password) are invalid after the upgrade and decryption causes this error. As a work around, you can use the apex_instance_admin package to overwrite the invalid passwords. The following code shows how decryptio
Apr 2012 15:20:49 -0400 I figured it out. For reasons I'm not 100% sure, des allows me to encrypt a 14 character string while 3des doesn't. From: Kenneth Naim [mailto:kennethnaim@xxxxxxxxx] Sent: Monday, April 23, 2012 3:13 PM To: Oracle-L Group (oracle-l@xxxxxxxxxxxxx) Subject: DBMS_CRYPTO Error I took the following example from MOS note 956603.1 and https://community.oracle.com/thread/2455036 modified the key to use an md5 hash of a passphrase I made up. It runs without issue. Original with new key create or replace function encrypt(v_string in varchar2) return varchar2 is encrypted_raw RAW (2000); encryption_type PLS_INTEGER := SYS.DBMS_CRYPTO.ENCRYPT_DES + SYS.DBMS_CRYPTO.CHAIN_CBC + SYS.DBMS_CRYPTO.PAD_PKCS5; http://www.freelists.org/post/oracle-l/DBMS-CRYPTO-Error-Solution v_key raw(128) := utl_i18n.string_to_raw( 'b505560de8ca30bcb640dc5521ea75c3', 'AL32UTF8' ); begin dbms_output.put_line(v_key); encrypted_raw := DBMS_CRYPTO.ENCRYPT ( src => UTL_I18N.STRING_TO_RAW (v_string,'AL32UTF8'), typ => encryption_type, key => v_key ); return RAWTOHEX(encrypted_raw); end encrypt; / When I change the encryption_type to use triple des instead of des and chain_cdc to chain_ecb I get this error ORA-28817: PL/SQL function returned an error. ORA-06512: at "SYS.DBMS_CRYPTO_FFI", line 3 ORA-06512: at "SYS.DBMS_CRYPTO", line 13 ORA-06512: at "ENCRYPT", line 10 Modified to triple des. create or replace function encrypt(v_string in varchar2) return varchar2 is encrypted_raw RAW (2000); encryption_type PLS_INTEGER := DBMS_CRYPTO.ENCRYPT_3DES + DBMS_CRYPTO.CHAIN_ECB + DBMS_CRYPTO.PAD_NONE; --SYS.DBMS_CRYPTO.ENCRYPT_DES + SYS.DBMS_CRYPTO.CHAIN_CBC + SYS.DBMS_CRYPTO.PAD_PKCS5; v_key raw(256) := utl_i18n.string_to_raw( 'b505560de8ca30bcb640dc5521ea75c3', 'AL32UTF8' ); begin dbms_output.put_line(v_key); encrypted_raw := DBMS_CRYPTO.ENCRYPT ( src => UTL_I18N.STRING_TO_RAW (v_string,'AL32UTF8'), typ => encryption_type, key => v_key ); return RAWTOHEX(encrypted_raw); end
key touse an md5 hash of a passphrase http://grokbase.com/t/freelists.org/oracle-l/124qj7zg06/dbms-crypto-error I made up. It runs without issue.Original with new keycreate or replace function encrypt(v_string in varchar2) return varchar2 isencrypted_raw RAW (2000);encryption_type PLS_INTEGER https://ilovedatabase.wordpress.com/2009/03/15/dbms_crypto-package-error-management/ := SYS.DBMS_CRYPTO.ENCRYPT_DES +SYS.DBMS_CRYPTO.CHAIN_CBC + SYS.DBMS_CRYPTO.PAD_PKCS5;v_key raw(128) := utl_i18n.string_to_raw('b505560de8ca30bcb640dc5521ea75c3', 'AL32UTF8' );begindbms_output.put_line(v_key);encrypted_raw := DBMS_CRYPTO.ENCRYPT(src => UTL_I18N.STRING_TO_RAW (v_string,'AL32UTF8'),typ => encryption_type,key => v_key);return RAWTOHEX(encrypted_raw);end encrypt;/When oracle error I change the encryption_type to use triple des instead of des andchain_cdc to chain_ecb I get this errorORA-28817: PL/SQL function returned an error.ORA-06512: at "SYS.DBMS_CRYPTO_FFI", line 3ORA-06512: at "SYS.DBMS_CRYPTO", line 13ORA-06512: at "ENCRYPT", line 10Modified to triple des.create or replace function encrypt(v_string in varchar2) oracle error 28817 return varchar2 isencrypted_raw RAW (2000);encryption_type PLS_INTEGER := DBMS_CRYPTO.ENCRYPT_3DES+ DBMS_CRYPTO.CHAIN_ECB+ DBMS_CRYPTO.PAD_NONE;--SYS.DBMS_CRYPTO.ENCRYPT_DES + SYS.DBMS_CRYPTO.CHAIN_CBC +SYS.DBMS_CRYPTO.PAD_PKCS5;v_key raw(256) := utl_i18n.string_to_raw('b505560de8ca30bcb640dc5521ea75c3', 'AL32UTF8' );begindbms_output.put_line(v_key);encrypted_raw := DBMS_CRYPTO.ENCRYPT(src => UTL_I18N.STRING_TO_RAW (v_string,'AL32UTF8'),typ => encryption_type,key => v_key);return RAWTOHEX(encrypted_raw);end encrypt;/I need to use 3des and chain_ecb to replace a piece of an application thatis no longer begin used. Any help would be appreciated. I've searched MOSand google, tried it in every config I can think of but I still get thaterror.Thank you,Ken Naim_____Checked by AVG - www.avg.comVersion: 2012.0.1913 / Virus Database: 2411/4954 - Release Date: 04/23/12--http://www.freelists.org/webpage/oracle-l reply Tweet Search Discussions Search All Groups oracle-l 3 responses Oldest Nested Norman Dunbar Evening Ken, I'm not 100% sure as I'm away from my desk at present, but I think when I used DES3 a few years ago, I needed to
database link dba dbms_crypto decrypt directory dynamic encrypt encryption error function grant IBM images install java logon message nasdaq ora-1017 ORA-29280: invalid directory path ORACLE package password pl/sql sqlplus sun traders trigger update upgrade user username utl_file utl_file_dir veritabanı Categories NEWS ORACLE Calender March 2009 M T W T F S S « Feb Apr » 1 2345678 9101112131415 16171819202122 23242526272829 3031 Archive August 2009 July 2009 April 2009 March 2009 February 2009 Masterz Hasan Tonguç Yılmaz Jonathan Lewis Steven Feuerstein Tom Kyte Blog Stats 4,059 hits Masterz Hasan Tonguç Yılmaz Jonathan Lewis Steven Feuerstein Tom Kyte Meta Register Log in Subscribe Entries (RSS) Comments (RSS) « how to create file @10gR2 Oracle and Sun & Sun andOracle » DBMS_CRYPTO package - errormanagement Posted by ilovedatabase on 15 Mar 2009 If you receive error messages like; ORA-28817: PL/SQL function returned an error. ORA-06512: at "SYS.DBMS_CRYPTO_FFI", line XXX. ORA-06512: at "SYS.DBMS_CRYPTO", line XX .. etc. Then, check these conditions; * the encryption key and encryption type must be the same as while encrption/decryption *the character set used by Oracle and your machine must be overlapped *the data that you are decrypting is NOT the same as the one encrypted Like this:Like Loading... Related This entry was posted on 15 Mar 2009 at 02:17 and is filed under ORACLE. Tagged: character set, dbms_crypto, decrypt, encrypt, encryption, ORACLE, package, pl/sql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site. Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are commenting using your Twitter account. (LogOut/Change) You are commenting using your Facebook account. (LogOut/Change) You are commenting using your Google+ account. (LogOut/Change) Cancel Connecting to %s Notify me of new comments via email. « how to create file @10gR2 Oracle and Sun & Sun andOracle » Create a free website or blog at WordPress.com. %d bloggers like this: