Procedures can be scheduled as a job within by the Oracle database. These jobs appear as program "ORACLE@ (J000)" when they are running. They appear within the session browser but when they are selected the Current Statement tab simply shows "Sql body unavailable". I believe that the sql was displayed when the database was Oracle 9i. Is this something that can be fixed?
"SQL Body Unavailable" means there's no lines returned by Oracle, so there's nothing to show. Unfortunately this is the behavior of Oracle 10g and not a Toad bug. Toad runs the following query to obtain the statement. If you ran it in SQL Plus, it would also be blank.
SELECT SQL_TEXT FROM V$SQLTEXT_WITH_NEWLINES WHERE
HASH_VALUE=TO_NUMBER(:hash) ORDER BY PIECE
hash = '269058814'
