DBMS_OUTPUT and DBMS_RANDOM warning into IDE

Completed

Hello, I am working on a university project database, using ORACLE 11g.

In my code I often use these commands:

DBMS_OUTPUT.PUT_LINE

DBMS_RANDOM.VALUE

Both these commands are marked as "UNABLE TO RESOLVE SYMBOL..." like the code editor does not know or recognize them, it's kinda annoying to have all these commands marked in the editor since they tend to mix with other real warnings and errors.

 

Thanks for any answer or solution.

4 comments
Comment actions Permalink

Hi,

Do you write your code in console or in sql file?

Could you specify DataGrip version you use?

Thank you.

P.S.: There is an issue https://youtrack.jetbrains.com/issue/DBE-3776 you can vote for.

 

1
Comment actions Permalink

I wrote them in a SQL file which will be fed to the SQL*PLUS console, and that's exactly the same issue you linked. By the way i use the last data grip version.

 

I will vote for the issue you linked since it affects me too, yet 4 years and they did not even looked at it?Well..let's hope.

1
Comment actions Permalink

This is fixed by caching `PUBLIC` and `SYS` schemas. BTW, I also work with Postgres and
I'm caching Postgres `pg_catalog` and `information_schema` in each data source.

I wish DataGrip would provide an option to cache standard system schemas for the new data sources by default.

1
Comment actions Permalink

i found this little tricky button in Datagrip, it turns on dbms_output without any dbms_output.enable or set serveron etc.

Looked how this answer few hours...

1

Please sign in to leave a comment.