Genexus - SQL External Stores Procedures

List of external stored procedures : SelecProducIns SelecProducDel

Si son de in o out siempre poner output out

CREATE PROCEDURE [dbo].[SelecProducIns]
 @ProdCod int output
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;
 BEGIN TRANSACTION
 INSERT INTO [dbo].[PRODSELEC]([SelProCod])
 SELECT [ProdCod]  FROM [dbo].[PRODUCTOS]  where ProdCod=@ProdCod
 COMMIT TRANSACTION
END

CREATE PROCEDURE [dbo].[SelecProducDel]
  @ProdCod int output
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;
 BEGIN TRANSACTION
 delete   FROM [dbo].[PRODSELEC] where SelProCod=@ProdCod
 COMMIT TRANSACTION
END


//////////////////////////////////////////
extprog.ini en la razi de la kb

Si son de in o out siempre poner output out
[SelecProducIns]
ProgramType=StoredProcedure
ProgramName=SelecProducIns
ParmMode=out
ParmType=Number,4,0;
ParmName=ProdCod

[SelecProducDel]
ProgramType=StoredProcedure
ProgramName=SelecProducDel
ParmMode=out
ParmType=Number,4,0;
ParmName=ProdCod

////////////////////////////////////////


CALL('SelecProducIns', &ProdCod)
CALL('SelecProducDel', &ProdCod)