How can I retrieve the value of variables in a store procedure?

[luca]

How can I retrieve the value of variables in a store procedure?

This one retrive only the first variable (StoreProcedure.GetParameter(0))

StoreProcedure.CallProcedure ('SP_EMAIL_INS',[
parString,
AddressId,
Address,
mailDirection,
EmailItem.MailBody,
EmailItem.MailSubject,
EmailItem.MailImportance,
EmailItem.MailSent,
parString,
ToAddressList,
CcAddressList,
DossierIdList
]);

sessionMain.Commit ;

EmailItem.MailID := StoreProcedure.GetParameter(0);

EmailItem.JournalCode := StoreProcedure.GetParameter(1);

 

[clericil]

Luca,
check parameters position.

Originally posted by luca:
How can I retrieve the value of variables in a store procedure?

This one retrive only the first variable (StoreProcedure.GetParameter(0))

StoreProcedure.CallProcedure ('SP_EMAIL_INS',[
parString,
AddressId,
Address,
mailDirection,
EmailItem.MailBody,
EmailItem.MailSubject,
EmailItem.MailImportance,
EmailItem.MailSent,
parString,
ToAddressList,
CcAddressList,
DossierIdList
]);

sessionMain.Commit ;

EmailItem.MailID := StoreProcedure.GetParameter(0);

EmailItem.JournalCode := StoreProcedure.GetParameter(1);

 

[bchau]

I think the second GetParameter should be (9) instead of (1).
EmailItem.MailID := StoreProcedure.GetParameter(0);
EmailItem.JournalCode := StoreProcedure.GetParameter(9);