Return-path: Envelope-to: victor@ssf.com.mx Delivery-date: Thu, 27 Aug 2015 10:51:09 -0500 Received: from mail-lb0-f171.google.com ([209.85.217.171]:33300) by vishnu.hosting-mexico.net with esmtps (TLSv1.2:AES128-GCM-SHA256:128) (Exim 4.85) (envelope-from ) id 1ZUzSF-002LgA-CK for victor@ssf.com.mx; Thu, 27 Aug 2015 10:51:08 -0500 Received: by lbbsx3 with SMTP id sx3so14209303lbb.0 for ; Thu, 27 Aug 2015 08:51:05 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:date:message-id:subject:from:to :content-type; bh=5UHguEowkJOXjRR458uY2BvrDBpssX527r14f6v3w9w=; b=Mvc0vFZMIPOL/FIEfaZLpekNbqiVjAtZlx8UpwbxyGDCvRhYaVjdx9MhA9GToJQA5F ++Ars4m38U/x5/J8VpP2jZeP5QYYqgtXaTJG3nyDkPKbK9obvgC48OvDsbEDvKQ4a87D Qbs9dB4QCMryRqqTt7vx3P7p49dpoesxluMfiS8IT6qibhm5mMZ69P509WywHpQ4PhcD ZG1/3wUFNNoIfyL9t55MGZt6ocnJxCzN/dWbO8iEoic4Ojmm31Cd9sK3T0/DxA6XvdHj hEYAbC2ys6Ug6AIF5jGBylTDhxi46gXsqsvDcYC2uS2If+jCszs2ThqFqezCy7kd6jre d7Kw== X-Gm-Message-State: ALoCoQnaw3O1/TpaMhoIHGp0r+d10pxE37jOgBZyNKUg/pvnhA46K2kXRtzpP0VbKLkz2FpuN/yd MIME-Version: 1.0 X-Received: by 10.152.30.37 with SMTP id p5mr2660099lah.102.1440690665867; Thu, 27 Aug 2015 08:51:05 -0700 (PDT) Received: by 10.114.22.7 with HTTP; Thu, 27 Aug 2015 08:51:05 -0700 (PDT) X-Originating-IP: [187.254.0.126] Date: Thu, 27 Aug 2015 10:51:05 -0500 Message-ID: Subject: Ejemplo Stored procedure con Salida From: =?UTF-8?Q?Jorge_Garc=C3=ADa?= To: victor@ssf.com.mx Content-Type: multipart/alternative; boundary=089e0158c3c05ee542051e4cef0b X-Spam-Status: No, score=-0.7 X-Spam-Score: -6 X-Spam-Bar: / X-Ham-Report: Spam detection software, running on the system "vishnu.hosting-mexico.net", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see root\@localhost for details. Content preview: / CREACION || Procedimiento: p_imprime_poliza || Fecha: 10/08/2015 || Autor: Jose Marcos Juarez Solis || Analista: Jose Marcos Juarez Solis || FSW: Indra || Version: 1.1 || No. Proyecto: MU-2015-027891 || Nom. Proyecto: MX_IMP_Análisis Generación XML (HP Exstream) || Description: Se genera un procedimiento para generar la impresion [...] Content analysis details: (-0.7 points, 5.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- -0.7 RCVD_IN_DNSWL_LOW RBL: Sender listed at http://www.dnswl.org/, low trust [209.85.217.171 listed in list.dnswl.org] 0.0 HTML_MESSAGE BODY: HTML included in message -0.0 RCVD_IN_MSPIKE_H2 RBL: Average reputation (+2) [209.85.217.171 listed in wl.mailspike.net] X-Spam-Flag: NO --089e0158c3c05ee542051e4cef0b Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable /*----------------------------------- CREACION ---------------------------------------- || Procedimiento: p_imprime_poliza || Fecha: 10/08/2015 || Autor: Jose Marcos Juarez Solis || Analista: Jose Marcos Juarez Solis || FSW: Indra || Version: 1.1 || No. Proyecto: MU-2015-027891 || Nom. Proyecto: MX_IMP_An=C3=A1lisis Generaci=C3=B3n XML (HP Exstr= eam) || Description: Se genera un procedimiento para generar la impresion */------------------------------------------------------------------------= ------------ -- PROCEDURE p_imprime_poliza ( p_cod_cia IN a2000030.cod_cia %TYPE, p_num_poliza IN a2000030.num_poliza %TYPE, p_num_spto IN a2000030.num_spto %TYPE, p_tip_emision IN VARCHAR2, p_xml OUT CLOB ) IS BEGIN -- p_gen_impresion( p_cod_cia, p_num_poliza, p_num_spto, p_tip_emision ); -- g_app_emite_portal :=3D TRUE; -- p_xml :=3D g_xml; -- END p_imprime_poliza; Saludos. --=20 Ing. Jorge Garc=C3=ADa D=C3=ADaz Smart Software Factory Innovando en servicios tecnol=C3=B3gicos --089e0158c3c05ee542051e4cef0b Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGRpdiBkaXI9Imx0ciI+PGRpdj7CoCDCoCDCoCAvKi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tIENSRUFDSU9OIC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS08L2Rpdj48ZGl2PsKgIMKgfHwgwqAgUHJvY2VkaW1pZW50bzogwqAgcF9pbXByaW1lX3BvbGl6 YTwvZGl2PjxkaXY+wqAgwqB8fCDCoCBGZWNoYTogwqAgwqAgwqAgwqAgwqAgMTAvMDgvMjAxNTwv ZGl2PjxkaXY+wqAgwqB8fCDCoCBBdXRvcjogwqAgwqAgwqAgwqAgwqAgSm9zZSBNYXJjb3MgSnVh cmV6IFNvbGlzPC9kaXY+PGRpdj7CoCDCoHx8IMKgIEFuYWxpc3RhOiDCoCDCoCDCoCDCoEpvc2Ug TWFyY29zIEp1YXJleiBTb2xpczwvZGl2PjxkaXY+wqAgwqB8fCDCoCBGU1c6IMKgIMKgIMKgIMKg IMKgIMKgIEluZHJhPC9kaXY+PGRpdj7CoCDCoHx8IMKgIFZlcnNpb246IMKgIMKgIMKgIMKgIDEu MTwvZGl2PjxkaXY+wqAgwqB8fCDCoCBOby4gUHJveWVjdG86IMKgIMKgTVUtMjAxNS0wMjc4OTE8 L2Rpdj48ZGl2PsKgIMKgfHwgwqAgTm9tLiBQcm95ZWN0bzogwqAgTVhfSU1QX0Fuw6FsaXNpcyBH ZW5lcmFjacOzbiBYTUwgKEhQIEV4c3RyZWFtKTwvZGl2PjxkaXY+wqAgwqB8fCDCoCBEZXNjcmlw dGlvbjogwqAgwqAgU2UgZ2VuZXJhIHVuIHByb2NlZGltaWVudG8gcGFyYSBnZW5lcmFyIGxhIGlt cHJlc2lvbjwvZGl2PjxkaXY+wqAgwqAqLy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLTwvZGl2 PjxkaXY+wqAgwqAtLTwvZGl2PjxkaXY+wqAgwqBQUk9DRURVUkUgcF9pbXByaW1lX3BvbGl6YSAo IMKgPC9kaXY+PGRpdj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoHBfY29kX2NpYSDCoCDCoCDCoCBJ TiDCoCDCoGEyMDAwMDMwLmNvZF9jaWEgwqAgwqAlVFlQRSw8L2Rpdj48ZGl2PsKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgcF9udW1fcG9saXphIMKgIMKgSU4gwqAgwqBhMjAwMDAzMC5udW1fcG9saXph ICVUWVBFLDwvZGl2PjxkaXY+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqBwX251bV9zcHRvIMKgIMKg IMKgSU4gwqAgwqBhMjAwMDAzMC5udW1fc3B0byDCoCAlVFlQRSw8L2Rpdj48ZGl2PsKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgcF90aXBfZW1pc2lvbiDCoCBJTiDCoCDCoFZBUkNIQVIyLDwvZGl2Pjxk aXY+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqBwX3htbCDCoCDCoCDCoCDCoCDCoCBPVVQgwqAgQ0xP QjwvZGl2PjxkaXY+wqAgwqAgwqAgwqAgwqAgwqAgwqApIElTPC9kaXY+PGRpdj7CoCDCoEJFR0lO PC9kaXY+PGRpdj7CoCDCoCDCoCAtLTwvZGl2PjxkaXY+wqAgwqAgwqAgcF9nZW5faW1wcmVzaW9u KDwvZGl2PjxkaXY+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqBwX2NvZF9jaWEsPC9kaXY+PGRpdj7C oCDCoCDCoCDCoCDCoCDCoCDCoCDCoHBfbnVtX3BvbGl6YSw8L2Rpdj48ZGl2PsKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgcF9udW1fc3B0byw8L2Rpdj48ZGl2PsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg cF90aXBfZW1pc2lvbjwvZGl2PjxkaXY+wqAgwqAgwqAgwqAgwqAgwqAgwqApOzwvZGl2PjxkaXY+ wqAgwqAgwqAgLS08L2Rpdj48ZGl2PsKgIMKgIMKgIGdfYXBwX2VtaXRlX3BvcnRhbCA6PSBUUlVF OzwvZGl2PjxkaXY+wqAgwqAgwqAgLS08L2Rpdj48ZGl2PsKgIMKgIMKgIHBfeG1sIDo9IGdfeG1s OzwvZGl2PjxkaXY+wqAgwqAgwqAgLS08L2Rpdj48ZGl2PsKgIMKgRU5EIHBfaW1wcmltZV9wb2xp emE7PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5TYWx1ZG9zLjwvZGl2PjxkaXY+PGJyPjwvZGl2 Pi0tIDxicj48ZGl2IGNsYXNzPSJnbWFpbF9zaWduYXR1cmUiPjxkaXYgZGlyPSJsdHIiPjxwIHN0 eWxlPSJjb2xvcjpyZ2IoNjEsNjEsNjEpO2ZvbnQtc2l6ZTptZWRpdW07Zm9udC13ZWlnaHQ6Ym9s ZCI+SW5nLiBKb3JnZSBHYXJjw61hIETDrWF6PC9wPjxzcGFuIHN0eWxlPSJjb2xvcjpyZ2IoMjIs NTUsMTYzKTtmb250LXNpemU6bWVkaXVtO2ZvbnQtd2VpZ2h0OmJvbGQ7bWFyZ2luOjBweCI+U21h cnQgU29mdHdhcmUgRmFjdG9yecKgPGJyPjxwIHN0eWxlPSJmb250LXNpemU6c21hbGwiPklubm92 YW5kbyBlbiBzZXJ2aWNpb3MgdGVjbm9sw7NnaWNvczwvcD48L3NwYW4+PC9kaXY+PC9kaXY+DQo8 L2Rpdj4NCg== --089e0158c3c05ee542051e4cef0b--