i'm trying to hash or encrypt the password provided by the user in my apex oracle before store it in the DB table How can i do it ? i tried using DBMS_CRYPTO but it always generate an error saying

identifier 'DBMS_CRYPTO' must be declared

i have tried to grant execute privilege to PUBLIC and Administrator but no luck there

  • 1
    If you're using a common stored procedure like DBMS_CRYPTO in your own PL/SQL code, your database user must be granted the execute privilege on it explicitly - it cannot be granted through a role or through public.
    – pmdba
    Jul 23 at 19:41


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.