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!

DB Cache when coding a PL SQL Stored Procedure

120847Nov 4 2010 — edited Nov 7 2010

All,
I am coding a PLSQL Stored procedure that is being executed by Crystal Reports.
I am seeing a caching behavior that is causing me some issues.
Is there a command I can enter on my stored procedure to force purge or require the SP to not use any cache that may be outstanding?

I would like each execution oif the SP to build fresh all data.

Thanks for any suggestions.

Greg

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2010

Added on Nov 4 2010

17 comments

1,639 views