erika9star
Programmer
I'm attempting to use the sp_password stored procedure witin MS SQL Server in a PowerBuilder app.
The SQLCA.sqlerrtext returns "SQLState=S1093 Invalid Parameter Number"
I've tried eliminating one parameter at a time, to try to get rid of the error, but I'm having no luck. Any ideas?
Code:
DECLARE sp PROCEDURE FOR sp_password
@old = :s_old,
@new = :s_new,
@loginame = :s_login
using SQLCA;
SQLCA.Autocommit = true
EXECUTE sp ;
SQLCA.Autocommit = false
The SQLCA.sqlerrtext returns "SQLState=S1093 Invalid Parameter Number"
I've tried eliminating one parameter at a time, to try to get rid of the error, but I'm having no luck. Any ideas?