0

I need to PROVE that some Stored Procedure has been called.

This is a third-party database, so:

  • I can't ask to change SP
  • I can't ask to audit anything
  • I have no DBA access

This is what I have:

1) DO SOME THINGS ...
2) START FOO STORED PROCEDURE ...
   2.1) WAIT UTIL FOO COMPLETES ...
3) DO SOME OTHER THINGS ...

This is what I need:

1) DO SOME THINGS ...
2) START FOO STORED PROCEDURE ...
    2.1) RECEIVE A RESPONSE FROM ORACLE: "OK! FOO HAS BEEN STARTED!" ...     
    2.2) WAIT UTIL FOO COMPLETES ...
    2.3) RECEIVE A RESPONSE FROM ORACLE: "OK! FOO HAS BEEN FINISHED!" ...
3) DO SOME OTHER THINGS ...
Christian
  • 7,062
  • 9
  • 53
  • 79
  • 1
    `RECEIVE A RESPONSE FROM ORACLE: "OK! FOO HAS BEEN STARTED!"` and `I can't ask to change anything` are cancelling each other. – Sebas Nov 27 '14 at 15:20
  • I guess your only option is to find some effect that the procedure always has (e.g. does it write data to a table, or send output to dbms_output) and check for that effect. – Jeffrey Kemp Nov 27 '14 at 16:03

0 Answers0