This content has been marked as final. Show 4 replies
Can you please post a URL to that doc ref?
Also had a look and there's no trace of this call (11gr2). Searched the contents of +$ORACLE_HOME/rdbms/admin+ for the keywork reset_self and no hits.
Metalink note +PACKAGE DBMS_SESSION Specification [ID 67594.1]+ also does not list this call.
Keen on this type of feature myself - I have 24x7 code running and its a pain to interrupt this, shut it down, in order to perform a basic package update (where interface spec remains unchanged).
Thanks. Tried to submit a comment saying that the documentation refers to a non-existent procedure in DBMS_SESSION, but my ActiveScript browser plugin complained about a potential cross-site scripting (XSS) attack (thanks Oracle for not keeping to sensible and secure JScript standards) and then the website threw a HTTP 404.