|
este es el procedimiento que estoy usando
CREATE PROCEDURE spplanowinsiob
(
@conse char (9),--0
@cod_suc char (4),--1
@fec_operacion char (8),--2
@vlr_nominal char(15),--3
@vlr_pesos char (15),--4
@tip_moneda char (2),--5
@form_pago char (2),--6
@tip_iden char (2),--7
@num_iden char (15),--8
@nom_razsoc char (40),--9
@dir_eccion char (25),--10
@cod_depart char (3),--11
@cod_munic char (4),--12
@cod_inditel char (8),--13
@num_tel char (10),--14
@tip_transac char (4),--15
@nom_remit char (40),--16
@n_idremit char (15),--17
@tp_idremit char (25),--18
@pais_orig char (3),--19
@Ori_desti char (1),--20
@ciuor_dest char (20),--21
@entidad char (40),--22
@num_cuenb char (16),--23
@detalle char (43)--24
)
AS
begin
Insert into PLANOWINSIOB(conse,cod_suc,fec_operacion,vlr_nominal,vlr_pesos,tip_moneda,
form_pago,tip_iden,num_iden,nom_razsoc,dir_eccion,cod_depart,cod_munic,cod_inditel,
num_tel,tip_transac,nom_remit,n_idremit,tp_idremit,pais_orig,Ori_desti,ciuor_dest,
entidad,num_cuenb,detalle)
Values (@conse,@cod_suc,@fec_operacion,@vlr_nominal,@vlr_pesos,@tip_moneda,
@form_pago,@tip_iden,@num_iden,@nom_razsoc,@dir_eccion,@cod_depart,@cod_munic,@cod_inditel,
@num_tel,@tip_transac,@nom_remit,@n_idremit,@tp_idremit,@pais_orig,@Ori_desti,@ciuor_dest,
@entidad,@num_cuenb,@detalle)
end
GO
|