| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Debug PL/SQL Procedure |
« View previous topic :: View next topic » |
| Author |
Message
|
| kash3338 |
 Posted: Wed Feb 08, 2012 5:39 am Post subject: Debug PL/SQL Procedure |
 |
|
Shaman
Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India
|
Hi,
I have invoked a PLSQL procedure from my message flow and the PLSQL inserts into 5 different tables. When I run the flow, I dont get any errors, but I am not able to view them in the DB tables. How do I debug the PLSQL from my flow? I dont see any logs in UserTrace. |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Wed Feb 08, 2012 5:51 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Debugging this code is no different than any other WMB code. They demonstrate this procedure in the WM663 class. Have you taken the class ?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| kash3338 |
| Posted: Wed Feb 08, 2012 5:55 am Post subject: |
|
|
Shaman
Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India
|
| lancelotlinc wrote: |
| Debugging this code is no different than any other WMB code. |
I want to debug the PLSQL procedure and not the WMB-ESQL code. Is there a way to capture the trace of the PLSQL execution step by step? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Feb 08, 2012 6:18 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| kash3338 wrote: |
| lancelotlinc wrote: |
| Debugging this code is no different than any other WMB code. |
I want to debug the PLSQL procedure and not the WMB-ESQL code. Is there a way to capture the trace of the PLSQL execution step by step? |
Yes. Go sit with your DBA until he explains how. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
