Visit Map

Thursday, September 02, 2010

The stored procedure expects a parameter error

When executing your stored procedures through Sybase ace driver, you may get an error the stored procedure expects as a parameter even your passing the parameters
Ex getEmployes
assgin parameters to command
execute the command.
you may get an error saying no parameters found for the stored procedure
To resolve this error
you need to assign stored procedure as getEmployees ?,?,? (No of parameters that stored procedure takes)