Method R Discussion GroupMethod R helps developers, DBAs, and decision-makers optimize Oracle-based software in every phase of the software life cycle. |
||
Discuss Method R products, techniques, and events. Ask new questions or post your own responses. |
When profiling with the Hotsos Profiler Extension for SQL Developer, it is possible to receive an ORA-00904: Invalid Identfier message. This occurs when the schema you are using has not been granted execute authority to DBMS_LOB.
If you see this error, use the following command to grant the proper authority: EXECUTE IMMEDIATE 'GRANT EXECUTE ON DBMS_LOB TO ' || v_schema ; This grant will be built into the Profiler Extension for release 1.1.3. |
Powered by FogBugz