Home » SQL & PL/SQL » SQL & PL/SQL » Procedure call through java
Procedure call through java [message #643018] Fri, 25 September 2015 09:53 Go to next message
rohit_shinez
Messages: 139
Registered: January 2015
Senior Member
Hi,

I am having a procedure which is called through java by passing parameters, is there a way to log in my user defined log_table how much time the procedure is called by java
Re: Procedure call through java [message #643019 is a reply to message #643018] Fri, 25 September 2015 10:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
rohit_shinez wrote on Fri, 25 September 2015 07:53
Hi,

I am having a procedure which is called through java by passing parameters, is there a way to log in my user defined log_table how much time the procedure is called by java



modify procedure to INSERT "audit" record into new run time capture table
Re: Procedure call through java [message #643020 is a reply to message #643019] Fri, 25 September 2015 10:20 Go to previous messageGo to next message
rohit_shinez
Messages: 139
Registered: January 2015
Senior Member
you mean to say at the beginning of the procedure to insert record in log_table using autonomous transaction
Re: Procedure call through java [message #643021 is a reply to message #643020] Fri, 25 September 2015 11:25 Go to previous message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Could be one implementation.
Or why not log the call in your Java procedure?

Previous Topic: Using Procedure/Function in a Select Statement
Next Topic: NVL vs IS NULL
Goto Forum:
  


Current Time: Sun Jun 28 19:15:08 CDT 2026