associate a sql 2000 server stored proc with a variable

hi guys i need to accomplish the following...
firstly i have a adostored proc and a datasetprovider on a datamodule(this connects to a web module/web service)
on the client side i have a clientdataset, what i need to do is get a value back from the stored proc which when run thru sql like
exec @temp = Myproc '1','2' returns a value
in delphi when passing the necessary parameters i get missing data packet errors when trying to execute thru the clientdataset. what could i be missing ?