I've set up a new Oracle database using exp/imp from an existing db. I'm trying to get all the pieces back together, and I've hit a roadblock with the ST_GEOMETRY type. It's invalid, and when I try to compile it, I get:
PLS-00201: identifier 'DBMS_CRYPTO' must be declared
I've granted execute on DBMS_CRYPTO to the sde user. It still won't compile. The public synonym is still valid. Am I forgetting something?
Thanks,
Harry
