IDispatch Error #3092 when I execute a stored proc that does an insert on a Sybase SQL Anywhere. Why can I find the meaning of such errors.
-
I get an IDispatch error #3092 when I execute a stored proc that does a rather basic insert into a Sybase SQL Anywhere database. I have reviewed the stored proc more than a dozen times, but cannot find anything wrong with it. Where can I find the real meaning of such errors. Does anyone have an idea of what could be happening. I have posted the stored proc below. Error lookup does not give the correct result. Create Procedure PersonAdd ( @EntCode varchar(3), @Accd varchar(3), @FirstName varchar(40), @MiddleName varchar(40), @LastName varchar(40), @Suffix varchar(15), @Title varchar(25), @PrevName varchar(35), @Alias varchar(35), @SSN varchar(11), @BirthDate datetime, @Sex varchar(6), @IDTypeCode varchar(10), @IDNo varchar(15), @IDState varchar(15), @TaxID varchar(11), @EthnicCode varchar(10), @RaceCode varchar(10) ) AS INSERT INTO Person (EntCode, Accd, FirstName, MiddleName, LastName, Suffix, Title, PrevName, Alias, SSN, BirthDate, Sex, IDTypeCode, IDNo, IDState, TaxID, EthnicCode, RaceCode, DateCreated, UserCreated) VALUES (@EntCode, @Accd, @FirstName, @MiddleName, @LastName, @Suffix, @Title, @PrevName, @Alias, @SSN, @BirthDate, @Sex, @IDTypeCode, @IDNo, @IDState, @TaxID, @EthnicCode, @RaceCode, GetDate(), user_name()) DECLARE @PersonID INT SELECT @PersonID = @@IDENTITY RETURN (@PersonID) GO
-
I get an IDispatch error #3092 when I execute a stored proc that does a rather basic insert into a Sybase SQL Anywhere database. I have reviewed the stored proc more than a dozen times, but cannot find anything wrong with it. Where can I find the real meaning of such errors. Does anyone have an idea of what could be happening. I have posted the stored proc below. Error lookup does not give the correct result. Create Procedure PersonAdd ( @EntCode varchar(3), @Accd varchar(3), @FirstName varchar(40), @MiddleName varchar(40), @LastName varchar(40), @Suffix varchar(15), @Title varchar(25), @PrevName varchar(35), @Alias varchar(35), @SSN varchar(11), @BirthDate datetime, @Sex varchar(6), @IDTypeCode varchar(10), @IDNo varchar(15), @IDState varchar(15), @TaxID varchar(11), @EthnicCode varchar(10), @RaceCode varchar(10) ) AS INSERT INTO Person (EntCode, Accd, FirstName, MiddleName, LastName, Suffix, Title, PrevName, Alias, SSN, BirthDate, Sex, IDTypeCode, IDNo, IDState, TaxID, EthnicCode, RaceCode, DateCreated, UserCreated) VALUES (@EntCode, @Accd, @FirstName, @MiddleName, @LastName, @Suffix, @Title, @PrevName, @Alias, @SSN, @BirthDate, @Sex, @IDTypeCode, @IDNo, @IDState, @TaxID, @EthnicCode, @RaceCode, GetDate(), user_name()) DECLARE @PersonID INT SELECT @PersonID = @@IDENTITY RETURN (@PersonID) GO