danielscorpio
23-01-2006, 16:30:54
saludos me llamo daniel
solo quiero saber la opinion sobre este procediemiento almacenado hecho en mysql
CREATE PROCEDURE `procedimiento`(IN_DATOS datetime, IN_DISPOSITION varchar(45), OUT uniqueid_a varchar(32), OUT userfield_b varchar(255), OUT accountcode_c varchar(20), OUT src_d varchar(80), OUT dst_e varchar(80), OUT dcontext_f varchar(80), OUT clid_g varchar(80), OUT channel_h varchar(80), OUT dstchannel_i varchar(80), OUT lastapp_j varchar(80), OUT lastdata_k varchar(80), OUT calldate_l datetime, OUT duration_m int(11), OUT billsec_q int(11), OUT disposition_n varchar(45), OUT amaflags_o int(11))
BEGIN
IF EXISTS (select * from cdr where calldate like IN_DATOS) THEN
SELECT uniqueid, userfield, accountcode, src, dst, dcontext, clid, channel, dstchannel, lastapp, lastdata, calldate, duration, billsec,disposition, amaflags into uniqueid_a, userfield_b, accountcode_c, src_d, dst_e, dcontext_f, clid_g, channel_h, dstchannel_i, lastapp_j, lastdata_k, calldate_l, duration_m, billsec_q, disposition_n, amaflags_o from cdr where calldate like IN_DATOS;
END IF;
IF EXISTS (select * from cdr where calldate like IN_DISPOSITION) THEN
SELECT uniqueid, userfield, accountcode, src, dst, dcontext, clid, channel, dstchannel, lastapp, lastdata, calldate, duration, billsec,disposition, amaflags into uniqueid_a, userfield_b, accountcode_c, src_d, dst_e, dcontext_f, clid_g, channel_h, dstchannel_i, lastapp_j, lastdata_k, calldate_l, duration_m, billsec_q, disposition_n, amaflags_o from cdr where calldate like IN_DISPOSITION;
END IF;
END
sus opiniones las puedo recibir aqui en el foro, o tambien hagamelo saber a daniel21gt@hotmail.com o el messenger de alguno de ustedes que sepan sobre el este tema
muchas gracias
solo quiero saber la opinion sobre este procediemiento almacenado hecho en mysql
CREATE PROCEDURE `procedimiento`(IN_DATOS datetime, IN_DISPOSITION varchar(45), OUT uniqueid_a varchar(32), OUT userfield_b varchar(255), OUT accountcode_c varchar(20), OUT src_d varchar(80), OUT dst_e varchar(80), OUT dcontext_f varchar(80), OUT clid_g varchar(80), OUT channel_h varchar(80), OUT dstchannel_i varchar(80), OUT lastapp_j varchar(80), OUT lastdata_k varchar(80), OUT calldate_l datetime, OUT duration_m int(11), OUT billsec_q int(11), OUT disposition_n varchar(45), OUT amaflags_o int(11))
BEGIN
IF EXISTS (select * from cdr where calldate like IN_DATOS) THEN
SELECT uniqueid, userfield, accountcode, src, dst, dcontext, clid, channel, dstchannel, lastapp, lastdata, calldate, duration, billsec,disposition, amaflags into uniqueid_a, userfield_b, accountcode_c, src_d, dst_e, dcontext_f, clid_g, channel_h, dstchannel_i, lastapp_j, lastdata_k, calldate_l, duration_m, billsec_q, disposition_n, amaflags_o from cdr where calldate like IN_DATOS;
END IF;
IF EXISTS (select * from cdr where calldate like IN_DISPOSITION) THEN
SELECT uniqueid, userfield, accountcode, src, dst, dcontext, clid, channel, dstchannel, lastapp, lastdata, calldate, duration, billsec,disposition, amaflags into uniqueid_a, userfield_b, accountcode_c, src_d, dst_e, dcontext_f, clid_g, channel_h, dstchannel_i, lastapp_j, lastdata_k, calldate_l, duration_m, billsec_q, disposition_n, amaflags_o from cdr where calldate like IN_DISPOSITION;
END IF;
END
sus opiniones las puedo recibir aqui en el foro, o tambien hagamelo saber a daniel21gt@hotmail.com o el messenger de alguno de ustedes que sepan sobre el este tema
muchas gracias