I'm trying to use a stored procedure on Sybase ASE. All works fine as long as the stored procedure doesn't use any input parameters. When I use an input parameter I get the error : 'Procedure TV_testOutputParams_simple expects parameter @type_in, which was not supplied. '. On SQL Server, I have no problems.
Has anybody experience with this ?
Stored procedure on Sybase ASE
Moderators: chulett, rschirm, roy
Are you changing the stored procedure stage "type"? If you now have both input and output parameters it should be changed to "transform". If you have only input parameters and no output parameters it should be set to "target".
I checked the Connectivity Guide to Stored Procedures and it does say that Sybase is supported and the restrictions aren't related to this.
I checked the Connectivity Guide to Stored Procedures and it does say that Sybase is supported and the restrictions aren't related to this.