Hi,
I am currently using the free public oracle apex workspace provided from oracle, the one which you create for free.
I was wondering if it would be possible to grant dbms_crypto permissions to the user/schema i am using? I did try with grant execute on sys.dbms_crypto to myuser; (and yes I did replace myuser with my current schema, I even tried sysadmin for that matter), but I got the following error.
ORA-00942: table or view does not exist
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_200200", line 626
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_200200", line 612
ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 1749
If anyone has any idea, I would very much appreciate the help.
P.S : I Did try this locally on my machine and it worked, but I wanted to use the free tier apex provided from oracle.