Oracle Application Express (APEX)


DBMS_CRYPTO in APEX 5 with Oracle 11G


I need to encrypt my password and then the encrypted value will be stored in database. I am thinking to use DBMS_CRYPTO, following this tutorial: http://www.orafaq.com/forum/t/183098/So, I granted DBMS_CRYPTO to user APEX_050000 and granted is successful. Then I created a PL/SQL process: DECLAREl_hash raw(2000);BEGINl_hash := DBMS_CRYPTO.hash(utl_i18n.string_to_raw (par_password || par_id || upper(par_username),'AL32UTF8'),dbms_crypto.hash_sh1);END;This code seems doesn't work because when I validated it, it gave me error: ORA-06550: line 6, column 11: PLS-00201: identifier 'DBMS_CRYPTO' must be declared ORA-06550: line 6, column 1: PL/SQL: Statement ignoredWhat should I do to fix this? Based on this book "Expert Oracle Application Express Security", APEX 5 supports DBMS_CRYPTO.Thank you.
That's a permission problem.  You don't grant execute to APEX_050000, you grant it to your workspace parsing schema.   Hope this helps,Paul
Yeaaaay!! It works now! Thank you soooo muuuch!

Related Links

Displaying multiple rows in html
URL Redirect Button Problem
PK in Collections
ApEx and SSO
Bug? Copy page within an application not updating everything
Collections: get member sequence number
Some text errors in HTML DB 2.0.0.00.49
Database security
Workarea Password reset
Application level authorization scheme
HTMLDB 1.5 to 2.0???
Data Load/Unload Function - Very Slow
Column background color
Appex for Oracle10gR2 for Windows 2003 64 x86, help!
Derived Column Name
what this err means?

Categories

ORACLE DEV
Oracle Database + Options
Designer
Replication
Service
E-Commerce (iStore)
Calendar
Database Archived Forums
On Demand: SaaS and Ma...
Install (Korean)
SQL*Net (Korean)
NLS (Korean)
Performance Tuning (Ko...
Discoverer (Korean)
System Management and ...
JD Edwards World Archi...
Industrial Manufacturing
Hyperion Developer Net...
Master Data Management...
Sales
Query & Analysis
CRM On Demand Administ...
Communications Presence
weblogic.developer.int...
weblogic.developer.int...
weblogic.developer.int...
weblogic.developer.int...
UI Customization
BEA Guardian Newsgroups
Primavera Contractor
BEA WebLogic RFID (Chi...
Complex Event Processing
User Productivity Kit ...
Training / Learning / ...
Reflections & Referenc...
Systems Development an...
Solaris Networking
Sun Web Developer Pack...
Sun Java Wireless Toolkit
Java SE Embedded
Web Space Server
General Discussion [AR...
ONE Application Server 6
AutoVue Enterprise Vis...
EPM System Infrastructure
ADF Mobile Preview
Endeca Experience Mana...
プログラミング一般
Fusion Applications
Oracle Servlet Develop...
Discuss
E10 Users
Webcast Central
Huntsville, Alabama El...
OMC French User Group ...
Oracle Compute Cloud S...
Computershare
Grupo Eloquea – Latino...
Eloqua Brasil
#Java20
Java Lambda MOOC
Getting Started
OMC - Industry Solutio...
Oracle Business Intell...
Oracle x86 Servers
JXTA Community Forum
Free & Open Source Sof...
OpenStack for Oracle S...
SPOUG - Spain Oracle U...
The Markies
Trade Promotions
North Central Oracle A...
Dallas Eloqua Users
Archived Forums
Berkeley DB
개발자 (Korean)
Products - Application...
Archived Newsgroups
weblogic.developer.int...
Identity Services
Web Application Develo...
.NET (Japanese)
Oracle Business Intell...
Technical Questions
Linux (Japanese)
General FLEXCUBE Quest...
English
Develop
Transportation Management
Test Partner Industry ...

Resources

Encrypt Message



code
soft
python
ios
c
html
jquery
cloud
mobile