Good afternoon,
The stored procedure is supposed to match the input vin to a vin in another
table. Then within the SP I want to update a different table with the values
retrieved from the first select.
I am executing a stored procedure and I am getting this error:
14:44:27 [SELECT - 0 row(s), 0.000 secs] [Error Code: 335544343, SQL State:
HY000] GDS Exception. 335544343. invalid request BLR at offset 49
No message for code 335544868 found.
null
I can't find any information on what is causing this error.
Here is the SP:
CREATE or Alter PROCEDURE GetBikeUpdate
( In_Vin varchar(8))
RETURNS
( Out_BikeYear varchar(50),
Out_BikeMake varchar(50),
Out_BikeModel varchar(23),
Out_BikeVin varchar(50),
Out_BikeLast8Vin varchar(8))
AS
--DECLARE VARIABLE variable_name < datatype>;
BEGIN
/* write your code here */
FOR SELECT BikeYEAR, BikeMAKE, BikeMODEL, vin, LAST8VIN FROM
BIKEHISTORY_LISTDATE
WHERE :In_vin = last8vin
INTO :Out_BikeYear, :Out_BikeMake, :Out_BikeModel, :Out_BikeVin,
:Out_BikeLast8Vin
DO
BEGIN
If (:In_vin = :Out_BikeLast8Vin) then BEGIN
Update Total_sales_to_part_cost_match
set TSPM_BIKEYEAR = :Out_BikeYear,TSPM_BIKEMAKE = :Out_BikeMake,
TSPM_BIKEMODEL = :Out_BikeModel, TSPM_LAST8VIN = :Out_BikeLast8Vin;
End
End
END;
Here is the statement to execute the SP.
select * from GetBikeUpdate ('7M005597');
Any help or direction would be greatly appreciated. This is my first attempt
at SP in Firebird so any guidance/correction is also appreciated.
Thank you for your time.
Jim
