ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » Calling Stored Procedure from Child BO

Post new topic  Reply to topic
 Calling Stored Procedure from Child BO « View previous topic :: View next topic » 
Author Message
keenlearner
PostPosted: Tue Apr 03, 2007 9:28 pm    Post subject: Calling Stored Procedure from Child BO Reply with quote

Acolyte

Joined: 24 Aug 2006
Posts: 62
Hi Guys
I am using WBIA Oracle Applications Adapter with Windowx XP Service Pack 2.
I am tyring to do an outboud process with Parent Child BO.
I am calling AfterRetrieveSP from child object.
my BO is attached below.
Quote:

[ReposCopy]
Version = 3.0.0
[End]
[BusinessObjectDefinition]
Name = EMP
Version = 3.0.0
AppSpecificInfo = TN=EMP;SCN=
[Attribute]
Name = NAME
Type = String
Cardinality = 1
MaxLength = 20
IsKey = false
IsForeignKey = false
IsRequired = false
AppSpecificInfo = CN=NAME
IsRequiredServerBound = false
[End]

[Attribute]
Name = DEPT
Type = String
Cardinality = 1
MaxLength = 10
IsKey = false
IsForeignKey = false
IsRequired = false
AppSpecificInfo = CN=DEPT
IsRequiredServerBound = false
[End]

[Attribute]
Name = MANAGERID
Type = String
Cardinality = 1
MaxLength = 22
IsKey = false
IsForeignKey = false
IsRequired = true
AppSpecificInfo = CN=MANAGERID:FK=MANAGER.MANAGERID
IsRequiredServerBound = false
[End]

[Attribute]
Name = EMPID
Type = String
Cardinality = 1
MaxLength = 22
IsKey = false
IsForeignKey = false
IsRequired = true
AppSpecificInfo = CN=EMPID
IsRequiredServerBound = false
[End]

[Attribute]
Name = RETURNVAL
Type = String
Cardinality = 1
MaxLength = 20
IsKey = false
IsForeignKey = false
IsRequired = false
IsRequiredServerBound = false
[End]
[Attribute]
Name = AfterRetrieveSP
Type = String
Cardinality = 1
MaxLength = 255
IsKey = false
IsForeignKey = false
IsRequired = false
AppSpecificInfo = SPN=RETURNVAL_TEST_TABLE;IP=EMPID;OP=RETURNVAL
IsRequiredServerBound = false
[End]
[Attribute]
Name = ObjectEventId
Type = String
Cardinality = 1
MaxLength = 255
IsKey = false
IsForeignKey = false
IsRequired = false
IsRequiredServerBound = false
[End]

[Verb]
Name = Create
[End]

[Verb]
Name = Retrieve
[End]

[Verb]
Name = Delete
[End]

[Verb]
Name = Update
[End]

[Verb]
Name = RetrieveByContent
[End]

[Verb]
Name = DeltaUpdate
[End]
[End]
[BusinessObjectDefinition]
Name = MANAGER
Version = 3.0.0
AppSpecificInfo = TN=MANAGER;SCN=

[Attribute]
Name = NAME
Type = String
Cardinality = 1
MaxLength = 50
IsKey = false
IsForeignKey = false
IsRequired = true
AppSpecificInfo = CN=NAME
IsRequiredServerBound = false
[End]

[Attribute]
Name = MANAGERID
Type = String
Cardinality = 1
MaxLength = 22
IsKey = true
IsForeignKey = false
IsRequired = false
AppSpecificInfo = CN=MANAGERID
IsRequiredServerBound = false
[End]
[Attribute]
Name = EMP
Type = EMP
ContainedObjectVersion = 3.0.0
Relationship = Containment
Cardinality = n
MaxLength = 22
IsKey = true
IsForeignKey = false
IsRequired = false
AppSpecificInfo = KEEP_RELATIONSHIP=true;CONTAINMENT=OWNERSHIP
IsRequiredServerBound = false
[End]
[Attribute]
Name = ObjectEventId
Type = String
Cardinality = 1
MaxLength = 255
IsKey = false
IsForeignKey = false
IsRequired = false
IsRequiredServerBound = false
[End]

[Verb]
Name = Create
[End]

[Verb]
Name = Delete
[End]

[Verb]
Name = DeltaUpdate
[End]

[Verb]
Name = Retrieve
[End]

[Verb]
Name = RetrieveByContent
[End]

[Verb]
Name = Update
[End]
[End]


But the stored procedure is not getting called The trace file this is given below.
Quote:

[Time: 2007/04/03 11:01:14.654] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering retrieve] ]
[Time: 2007/04/03 11:01:14.654] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting retrieve] ]
[Time: 2007/04/03 11:01:14.654] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute NAME with Value Gopi] ]
[Time: 2007/04/03 11:01:14.654] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute DEPT with Value SAP] ]
[Time: 2007/04/03 11:01:14.654] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute MANAGERID with Value 1] ]
[Time: 2007/04/03 11:01:14.654] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute EMPID with Value 2] ]
[Time: 2007/04/03 11:01:14.654] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering retrieve] ]
[Time: 2007/04/03 11:01:14.654] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting retrieve] ]
[Time: 2007/04/03 11:01:14.654] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute NAME with Value Tony] ]
[Time: 2007/04/03 11:01:14.654] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute DEPT with Value E63] ]
[Time: 2007/04/03 11:01:14.664] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute MANAGERID with Value 1] ]
[Time: 2007/04/03 11:01:14.664] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute EMPID with Value 1] ]
[Time: 2007/04/03 11:01:14.664] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering retrieve] ]
[Time: 2007/04/03 11:01:14.664] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting retrieve] ]
[Time: 2007/04/03 11:01:14.664] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute NAME with Value NO DEPT] ]
[Time: 2007/04/03 11:01:14.874] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute DEPT with Value aaaaaaaaaa] ]
[Time: 2007/04/03 11:01:14.874] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute MANAGERID with Value 1] ]
[Time: 2007/04/03 11:01:14.884] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute EMPID with Value 999] ]
[Time: 2007/04/03 11:01:14.884] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering retrieve] ]
[Time: 2007/04/03 11:01:14.884] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting retrieve] ]
[Time: 2007/04/03 11:01:14.884] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute NAME with Value BLANK DEPT VAL] ]
[Time: 2007/04/03 11:01:14.884] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute DEPT with Value ] ]
[Time: 2007/04/03 11:01:14.884] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute MANAGERID with Value 1] ]
[Time: 2007/04/03 11:01:14.884] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute EMPID with Value 998] ]
[Time: 2007/04/03 11:01:14.884] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering retrieve] ]
[Time: 2007/04/03 11:01:14.884] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting retrieve] ]
[Time: 2007/04/03 11:01:14.884] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute NAME with Value NO DEPT ATTR] ]
[Time: 2007/04/03 11:01:14.884] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute DEPT with Value ] ]
[Time: 2007/04/03 11:01:14.884] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute MANAGERID with Value 1] ]
[Time: 2007/04/03 11:01:14.884] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009] [Mesg: Setting attribute EMPID with Value 997] ]
[Time: 2007/04/03 11:01:14.894] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34503] [Mesg: No Stored Procedure verb object for AfterRetrieve!] ]
[Time: 2007/04/03 11:01:14.894] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering execSP] ]
[Time: 2007/04/03 11:01:14.894] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37014] [Mesg: No Stored Procedure to execute. Exiting method execSP()] ]
[Time: 2007/04/03 11:01:14.894] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34503] [Mesg: No Stored Procedure verb object for AfterRetrieve!] ]
[Time: 2007/04/03 11:01:14.894] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering execSP] ]
[Time: 2007/04/03 11:01:14.894] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37014] [Mesg: No Stored Procedure to execute. Exiting method execSP()] ]
[Time: 2007/04/03 11:01:14.894] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34503] [Mesg: No Stored Procedure verb object for AfterRetrieve!] ]
[Time: 2007/04/03 11:01:14.904] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering execSP] ]
[Time: 2007/04/03 11:01:14.904] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37014] [Mesg: No Stored Procedure to execute. Exiting method execSP()] ]
[Time: 2007/04/03 11:01:14.904] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34503] [Mesg: No Stored Procedure verb object for AfterRetrieve!] ]
[Time: 2007/04/03 11:01:14.904] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering execSP] ]
[Time: 2007/04/03 11:01:14.904] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37014] [Mesg: No Stored Procedure to execute. Exiting method execSP()] ]
[Time: 2007/04/03 11:01:14.904] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34503] [Mesg: No Stored Procedure verb object for AfterRetrieve!] ]
[Time: 2007/04/03 11:01:14.904] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering execSP] ]
[Time: 2007/04/03 11:01:14.904] [System: ConnectorAgent] [SS: OracleAppsConnector] [Thread: appPolling (#1247440506)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37014] [Mesg: No Stored Procedure to execute. Exiting method execSP()] ]


Can any one suggest the right ethod to call strore Procedure from Child BO
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » Calling Stored Procedure from Child BO
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.