Skip to Main Content

ORDS, SODA & JSON in the Database

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!

dbms_session.reset_package or modify_package_state?

Stew AshtonApr 18 2011 — edited Apr 19 2011
I have recently learned that mod_plsql calls dbms_session.reset_package frequently, however it is possible to configure a call to modify_package_state instead. I would like to know which procedure is used by the APEX Listener, whether the choice is configurable and if so how?

I am concerned about the additional parsing that results from calling reset_package.

Thanks in advance for any light you can shed on this.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2011
Added on Apr 18 2011
4 comments
466 views