altering procedure problem,please help.

[Guest_imported]

i'am working with IB6 and delphi.I have no problems with updating/altering procedure via IbConsole but if i try to update procedure via TIBQuery component i receive this error:
invalid request BLR at offset 384
Bad parameter number.
thanks in advance.

 

[svanels]

Are you altering a stored procedure or a table? S. van Els
SAvanEls@cq-link.sr

 

[Guest_imported]

I'am altering a stored procedure.Here is code:
ALTER PROCEDURE "UPDATE_STREAM"
(
"STREAMID" INTEGER,
"INSTANCEID" INTEGER,
"AUDIO_LEVEL" FLOAT,
"FILE_NAME" VARCHAR(260),
"STREAM_NAME" VARCHAR(40),
"STREAM_TYPE" INTEGER,
"VIDEO_INFOID" INTEGER,
"AUDIO_INFOID" INTEGER,
"IN_P" INTEGER,
"OUT_P" INTEGER,
"MAIN" VARCHAR(1),
"LANGUAGEID" INTEGER,
"STATUS" INTEGER
)
RETURNS
(
"OUTSTREAMID" INTEGER
)
AS
begin
if (streamid=0) then
begin
insert into stream(instanceid,audio_level,file_name,stream_name,stream_type,video_infoid,
audio_infoid,in_p,out_p,MAIN,LANGUAGEID,status) values instanceid,:audio_level,:file_name,:stream_name,:stream_type,
:video_infoid,:audio_infoid,:in_p,ut_p,:MAIN,:LANGUAGEID,:status);
outstreamid=gen_id(streamid_no,0);
end
else
begin
update stream set instanceid=:instanceid,audio_level=:audio_level,file_name=:file_name,
stream_name=:stream_name,stream_type=:stream_type,video_infoid=:video_infoid,audio_infoid=:audio_infoid,
in_p=:in_p,out_p=ut_p,MAIN=:MAIN,LANGUAGEID=:LANGUAGEID,status=:status where streamid=:streamid;
end
POST_EVENT 'STREAM_CHANGE';
end

the strange is that TIBQuery accept this sql string but if i try to commit changes i receive error.if i delete some code and make him smaller query work.Perhaps this is a bug in TIBQuery,i guess....

 

[Guest_imported]

i found where is the obstacle:TIBQuery has a parameter named 'ParamCheck'.if he is true(default),query can't calculate right count of parameters or something.However ,now everyting work properly.
Thanks for interesting ;-)


P.S
Excuse my english ,i haven't much time to practice speaking him ;-)

 

[Guest_imported]

i found where is the obstacle:TIBQuery has a parameter named 'ParamCheck'.if he is true(default),query can't calculate right count of parameters or something.However ,now everyting work properly.
Thanks for interesting ;-)


P.S
Excuse my english ,i haven't much time to practice speaking him ;-)

 

[svanels]

Your welcome, so when I come across, I will remember this S. van Els
SAvanEls@cq-link.sr