Firebird and Stored Procedures

I have a stored procedure that i would like to execute form a C# program.

What i need is the sql string to pass to a command object that will execute the stored procedure.

In MSSQL it would be exec <SP> <Parameter List> i believe. Can any give me the firebird equivalent?

NOTE: one of the parameters is a blob
cossy74Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
NorCal2612Connect With a Mentor Commented:
execute procedure procedure_name(prm1, prm2, ..., prmN);
0
 
Nick UpsonConnect With a Mentor Principal Operations EngineerCommented:
please show the interface definition of the stored procedure and give the version of firebird you are using.
0
 
cossy74Author Commented:
SET TERM ^ ;

CREATE PROCEDURE INSERT_PROCESSES(
  PROCESS_ID VARCHAR(15) CHARACTER SET NONE,
  DLL_ID INTEGER,
  CHAMELEON_ID INTEGER,
  DATA BLOB SUB_TYPE 1 CHARACTER SET NONE)
AS
BEGIN
INSERT INTO processes("PT_P_ID","PT_DLL_ID","PT_CONTEXT","PT_CURRENT_STEP","PT_TIMER_IN","PT_TIMER_OUT","PT_PRIORITY","PT_STATUS","PT_DATA_PTR","PT_CHAMELEON_ID")
VALUES(:PROCESS_ID,:DLL_ID,GEN_ID(CONTEXT_GEN,1),0,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,0,0,:DATA,:CHAMELEON_ID);
END^

SET TERM ; ^

Firebird version: 1.5.1
0
 
cossy74Author Commented:
Hi,

if you are looking at this the actual string is

select <stored_procedure> <param_1><param_2>.....<param_n>
0
All Courses

From novice to tech pro — start learning today.