duda con procedimiento almacenado
 

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 [email protected] o el messenger de alguno de ustedes que sepan sobre el este tema

muchas gracias