hi all,
i have problem with execute store_procedure from my application:
error message: "invalid request BLR 199 at offset function STRLEN is not
defined"
but if i call that procedure in EMS Interbase/Firebird Manager than there is no
error.
please help me.
tahan tobing
the code programm:
=====================================================
dacomm.CommandType = CommandType.StoredProcedure
dacomm.CommandText = "select * from PROC_NEIGH('" + cell + "')"
dacomm.Connection = myConnection
dacomm.ExecuteNonQuery()
=====================================================
CREATE PROCEDURE PROC_NEIGH ( FI_CELL_ID VARCHAR (10) CHARACTER SET NONE)
RETURNS ( I_SUM INTEGER)
AS declare variable v_ncell varchar(255);
declare variable v_ncell_length integer;
declare variable v_jumlahdata integer;
declare variable i integer;
declare variable v_cell_id varchar(10);
declare variable temp varchar(80);
BEGIN
update m_site_i set ncell_col=0;
select ncell from m_neighbor
where CELL=:FI_CELL_ID
into :v_ncell;
v_ncell_length = strlen(trim(v_ncell)); --trim utk hilangkan spasi
v_jumlahdata=(v_ncell_length+1) / 8;
i=1;
while (i<=v_jumlahdata) do
begin
v_cell_id=substrlen(v_ncell,((i-1)*8)+1,8);
v_cell_id=trim(v_cell_id);
I_SUM=i;
update m_site_i set ncell_col=1 where cell = :v_cell_id;
suspend;
i=i+1;
end
END
=======================================================================
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
