Luca,
check parameters position.
[quote]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);[/quote]