Skip to Main Content
Forums

SQL & PL/SQL

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!

EXECUTE IMMEDIATE sometimes doesn't retrieve any information

User_HIE3GDec 11 2020

A PL/SQL function that retrieve data from a plain SQL query using EXECUTE IMMEDIATE, DBMS_SQL package, Ref Cursor, or also from a ADF View Object it is not returning any rows sometimes.
We've already tried the following things:
Checked that the plain query returns rows using SQL Developer.
We Separated the session by using a JOB that calls the function that retrieve the information (DBMS_JOB).
Using NO_RESULT_CACHE hint with ALTER SESSION SET RESULT_CACHE_MODE = MANUAL (without any memory flushing)
All queries are for a specific table but using different WHERE clause.
Any idea or known behaviour about our problem?

Comments

morgalr

That is a lot of code to go through, so I am not.

Let me ask you this:  I see you have a portion that is marked as recursive, do you recursively call the loading of the images?  If you do therein is your problem.

RuGI:.

Have you tried to define your Layout at  level of the class as static attribute?
You only require one.


Each time you use a BufferedImage, after painting the image invokes flush


picture.flush();

picture = null;

---

RuGI

Max8090-JavaNet

Thanx for the answer.

Can you tell me, which lines are recursive?

It was not my intent to do a recursive call. If so, this could maybe the problem.

Max8090-JavaNet

Yes, but didn't help.

Max8090-JavaNet

The problem is solved. I don't use the class OverlayLayout anymore. The layout looks quite different, but now it works.

1 - 5

Post Details

Added on Dec 11 2020
#cache, #dynamic, #issue, #pl-sql, #sql
3 comments
244 views