Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

4.2EA2 Locking up when debugging anonymous procedure

Lawrence_CFeb 15 2017 — edited Mar 1 2017

Hi

4.2EA2 is locking up when debugging an anonymous procedure.

To recreate, open an sql worksheet and write an anonymous procedure. Right click in tyhe worksheet and select Debug.

At this point, no debug session is initiated and SQLDEVELOPER becomes unresponsive.

In previous 4.1 releases, following the above process would result in a new tab be opened with the code of the anonymopus procedure and debugging initiated.

Regards

Lawrence Chitty

Comments

SriniVEERAVALLI
Answer
You have to execute only 1 EP for both Incr and Full loads, followed by another custom EP which set the DAC refresh table(W_ETL_REFRESH_DT) column as NULL.
ex:UPDATE W_ETL_REFRESH_DT SET LAST_REFRESH_DT =NULL

You need to schedule the custom ep to run on only Saturdays just before your actual EP start time so that you can have DAC refresh dates are null and follow load would be full load.

You need to create a custom etl mapping so that you can set this.. that might be a command from session or workflow.

If helps pls mark as correct :)

Edited by: Srini VEERAVALLI on Jan 24, 2013 8:22 AM
Marked as Answer by user10920449 · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 29 2017
Added on Feb 15 2017
3 comments
231 views