Recent content by CoffeeK1d

I'm able to connect using an AD account.

In the SQL Window the parser does not like log_bulk_exceptions and mark_processed procedures in the declaration. This doesn't seem to be an issue for the Program Window. CREATE OR REPLACE PROCEDURE JGUST.SP_local_sub_proc ( p_acad_yr IN NUMBER ,p_lea_id IN...

I use DBMS_SCHEDULER mostly also on Linux we have a couple of cron jobs (equivalent to Windows Scheduler), finally, we also use SQL*Plus. It all depends on the problem you are trying to solve, which would be the best tool.

It looks like different behavior from before, but I do see that CA does return results from inside the CTE not being used in a way not previously tested. -- outside alias is y instead of reusing x. CA does provide listing from dual, but it shouldn't have access to that. WITH temp1 AS (SELECT...

I didn't see the fix listed, but indeed, Code Assistant is now displaying the expected results after installing 16.0.6.2170.

>>* Grid cell spacing and selection area could be too small >>* Ctrl-A did not always select all text in the current grid cell Installed 16.0.6.2170. Both grid cell spacing and CTRL-A in the current grid cell work great. Thank you for the fix.

That worked perfectly.

I changed the default startup connection to use my AD account. Now when I startup I am prompted to log in. Just clicking OK gets me past this prompt without issue. Can the startup sign me in, or is this a limitation of AD accounts?

I am finding it difficult to position my mouse within the two pixels from the edge to change the cursor to the entire cell select. I have no need to select some text inside a cell. I always need to select the entire cell for one or multiple columns. Could there please be a setting to default...

I found that the code assistant is not displaying results based on the current scope of the alias, but based on when the alias was first used. In the sample code below X was assigned to DUAL in the CTE but is not being used. The same alias X is being used in the main query, pointing to a...

-- ORA-01031: insufficient privileges -- WITHOUT FORCE: IDE popped up with an error message box and statusbar message stating ORA-01031: insufficient privileges -- WITH FORCE : IDE accepted view with a statbar message of 'Done in n.nnn seconds' CREATE OR REPLACE FORCE VIEW...

I'm recreating a view from the dev environment into my schema. During that process, the view was created with errors, but the application didn't notify me. Here are my questions: 1. How can I enable error messages like "ORA-24344: success with compilation error" to display when creating a...

There are a couple of weird issues when it comes to this. 1. There is only 1 caret displaying. It would be great to see multiple carets. 2. After using ++ from top to bottom direction, the bottom-most row has the single caret, but after you type something, it jumps to the top. Not an issue if...

I have run into multiple compile bugs and ultimately settled on calling DBMS_UTILITY.COMPILE_SCHEMA and then loop through invalid objects to execute the alter compile. This process addressed our main issue with being unable to recompile procs using macros even when they didn't change and were...

I was also able to reproduce the issue in 15.0.4. I tried 'select user, sysdate from dual;' and 'null', as you suggested. Both resulted in the test window hung, with the status bar indicating "Executing..." Attached are my two debug logs. Steps: 1. Open a test window Alt+t or...