Unable to Execute Customized Stored procedure in MSSQL with 9.5 SP1

Vinayak_Muzumdar_(vinayakmuzumdar_-_(deleted))

Hi All, We had developed customized modules in which we executed the procedure call in livelink. The statement read as follows:RecArray result = CAPI.ExecSP( connection, "dbo.nextval :A1, :A2","PROCESSSEQNO",res)in above statement nextval is store procedure created in MSSQL database.With Livelink 9.1 SP3 and SP4 this script used to work properly. But as we upgraded the system to Livelink 9.5 this script stopped working. We receive error in "result" variable.Also the MSSQL Master Stored Procedure gets executed properly in 9.5. It is our process related Stored Procedure that is not getting executed.Please suggest us something for above issue.

Hans Stoop

Message from Hans Stoop via eLinkWhat you can try is define the variable as 'Dynamic result' and see whatthe actual value is that is returned.Hans > -----Original Message-----> From: eLink Discussion: Development Discussion > [mailto:development@elinkkc.opentext.com] > Sent: maandag 9 januari 2006 7:14> To: eLink Recipient> Subject: Unable to Execute Customized Stored procedure in > MSSQL with 9.5 SP1> > Unable to Execute Customized Stored procedure in MSSQL with > 9.5 SP1 Posted by Muzumdar, Vinayak on 01/09/2006 01:09 AM> > Hi All,> > We had developed customized modules in which we > executed the procedure call in livelink. The statement read > as follows:> > RecArray result = CAPI.ExecSP( connection, "dbo.nextval :A1, > :A2","PROCESSSEQNO",res)> > in above statement nextval is store procedure created in > MSSQL database.With Livelink 9.1 SP3 and SP4 this script used > to work properly. But as we upgraded the system to Livelink > 9.5 this script stopped working. We receive error in "result" > variable.> > Also the MSSQL Master Stored Procedure gets executed properly > in 9.5. It is our process related Stored Procedure that is > not getting executed.> > Please suggest us something for above issue.> > [To reply to this thread, use your normal E-mail reply function.]> > ============================================================> > Discussion: Development Discussion> https://knowledge.opentext.com/knowledge/livelink.exe/open/786303> > Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe> > To Unsubscribe from this Discussion, send an e-mail to > unsubscribe.development@elinkkc.opentext.com.> > >