This content has been marked as final. Show 4 replies
bobmagan wrote:PLS-00201: identifier 'DBMS_LOB' must be declaredCheck the grant on the SYS.DBMS_LOB package
I show it as granted to public for execute and a public synonym by the same name.
Seeing you are getting an ORA error, I would assume you have made your connection properly.
Thanks. That was definitely the reason I was getting the LOB error. I granted execute to public and the error is gone... but for some reason it's still not bringing up APEX.
When I issue the URL I see it get changed to: http://localhost:8080/apex/f?p=4550:1:6705967235809 and it updated the browser tab name to 'Application Express Login', but my screen is blank. I don't see any errors in the dos window I started the apex listener in.
You have made a good database connection evidenced by the session assignment (the long number at the end)
You now have the classic "images missing" problem.
This is not a web server "error" to be seen as much as seen in the browser. You are missing the references to the static content that APEX uses in it's web pages.
Check that step in the installation guide and you will get some ideas on how to fix it in your server instance.
This should return the contents of a text file located in the "i" path on your web server. When it is installed correctly, you will see the full contents of the page.