I am finding the documentation at
http://documentation.informati...win533/dbsqlmss7.htm

and elsewhere thin lookingo for an example of calling a SQL stored procedure with bidrectional parameters and getting back the parameter values. For instance, this does not work:

SQL SQLMSS EX Plexus_Control.dbo.Error2_Add 1,6065,'Server Error','&FEXNAME','Failure to refresh synonym &SYNNAME *** RETCODE = &RETCODE *** FOCERRNUM = &FOCERRNUM',?/0,[...more params...];
TABLE FILE SQLOUT
PRINT *
END
-RUN


Anyone have experience with this? Thank you.

This message has been edited. Last edited by: TOM SCHULTE,

I feel it must have something to do with the sproc, which is very complex: TEXT/VARCAHR(MAX) inputs, many parameters, multiple output params, temp tabels, etc.

Using a synonym is an obvious approach, but that always yeileded FOC1487 errors.

Evemntually, I just made a simpler sproc to call the more complex one. After that, this worked as expected:

SQL SQLMSS EX Plexus_Control.dbo.Error_Add 1,6065,'Server Error','&FEXNAME','Failed refresh &SYNNAME; RETCODE &RETCODE; FOCERRNUM &FOCERRNUM','&WFRS_NAME','&WFRS_NAME','',?/0,?/'';

TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS Error_Add
END
-RUN

-READFILE Error_Add
-? &