topic Oracle 11g - ST_GEOMETRY won't compile in Data Management Questions https://community.esri.com/t5/data-management-questions/oracle-11g-st-geometry-won-t-compile/m-p/66014#M3790 <HTML><HEAD></HEAD><BODY><SPAN>I've set up a new Oracle database using exp/imp from an existing db.&nbsp; I'm trying to get all the pieces back together, and I've hit a roadblock with the ST_GEOMETRY type.&nbsp; It's invalid, and when I try to compile it, I get:</SPAN><BR /><BR /><SPAN>PLS-00201: identifier 'DBMS_CRYPTO' must be declared</SPAN><BR /><BR /><SPAN>I've granted execute on DBMS_CRYPTO to the sde user.&nbsp; It still won't compile.&nbsp; The public synonym is still valid.&nbsp; Am I forgetting something?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Harry</SPAN></BODY></HTML> Tue, 21 May 2013 18:12:45 GMT HarryBoswell 2013-05-21T18:12:45Z Oracle 11g - ST_GEOMETRY won't compile https://community.esri.com/t5/data-management-questions/oracle-11g-st-geometry-won-t-compile/m-p/66014#M3790 <HTML><HEAD></HEAD><BODY><SPAN>I've set up a new Oracle database using exp/imp from an existing db.&nbsp; I'm trying to get all the pieces back together, and I've hit a roadblock with the ST_GEOMETRY type.&nbsp; It's invalid, and when I try to compile it, I get:</SPAN><BR /><BR /><SPAN>PLS-00201: identifier 'DBMS_CRYPTO' must be declared</SPAN><BR /><BR /><SPAN>I've granted execute on DBMS_CRYPTO to the sde user.&nbsp; It still won't compile.&nbsp; The public synonym is still valid.&nbsp; Am I forgetting something?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Harry</SPAN></BODY></HTML> Tue, 21 May 2013 18:12:45 GMT https://community.esri.com/t5/data-management-questions/oracle-11g-st-geometry-won-t-compile/m-p/66014#M3790 HarryBoswell 2013-05-21T18:12:45Z