Karena Form Oracle Apps running di Application Server, maka kita perlu upload file csv nya ke Application Server jg.
Tapi klo mau lebih mudah, pake psp aj. Oracle Apps dah punya package untuk menangani kebutuhan upload data dari file csv. Tapi maaf, saya lupa namanya. Klo ga salah, kedengeran seperti FND_WEB%. Teman2 lain ada yg tau? CMIIW ----- Original Message ---- From: Gita cantiq <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, March 5, 2008 12:08:39 PM Subject: [indo-oracle] Tanya lage.... :) Dear Master oracle, Mo tanya nih, Saya buat aplikasi kecil menggunakan form oracle dan nantinya akan di-copykan di Oracle Application. Tujuannya bila saya tekan satu button, dengan trigger when-button- pressed; maka file excel dengan type csv file akan masuk ke tabel di Oracle Application. Masalahnya kalau saya buat hanya di level form biasa, dan form ini tidak saya copykan ke Oracle Apps, maka data excel type csv file ini masuk ke table oracle; tapi begitu form ini saya copy ke oracle apps; maka data dari csv file ini tidak pernah ke-insert di table oraclenya. Untuk jelasnya saya kirimkan trigger when-button- pressed-nya : DECLARE v_filename_d VARCHAR2(256) := '/usr/tmp/gt_ prod_family_ detail.csv' ; v_file_d TEXT_IO.file_ type; v_text_d VARCHAR2(32767) ; n_pf_d NUMBER; n_item_code_ d NUMBER; t_pf1_d NUMBER; t_pf2_d NUMBER; t_item_code1_ d NUMBER; t_item_code2_ d NUMBER; t_sisa_d NUMBER; v_pf_d VARCHAR2(10) ; v_item_code_ d VARCHAR2(20) ; v_min_prod_qty_ per_week_ d PLS_INTEGER; BEGIN v_file_d := TEXT_IO.fopen( v_filename_ d, 'r'); LOOP TEXT_IO.get_ line(v_file_ d, v_text_d); n_pf_d := INSTR(v_text_ d,chr(44) ,1,1); n_item_code_ d := INSTR(v_text_ d,chr(44) ,1,2); t_pf1_d := n_pf_d - 1; t_pf2_d := n_pf_d + 1; t_item_code1_ d := n_item_code_ d - (n_pf_d + 1); t_item_code2_ d := n_item_code_ d + 1; t_sisa_d := length(v_text_ d) - n_item_code_ d; v_pf_d := REPLACE(SUBSTR( v_text_d, 1,t_pf1_d) ,'"',NULL) ; v_item_code_ d := REPLACE(SUBSTR( v_text_d, t_pf2_d,t_ item_code1_ d),'"',NULL) ; v_min_prod_qty_ per_week_ d := REPLACE(SUBSTR( v_text_d, t_item_code2_ d,t_sisa_ d),'"',NULL) ; INSERT INTO GT_PF_PROD_FAMILY_ DETAIL (PROD_FAMILY, ITEM_CODE, MIN_PROD_QTY_ PER_WEEK, CREATED_BY, CREATED_DATE) VALUES (v_pf_d, v_item_code_ d, 500, 0, sysdate); COMMIT; END LOOP; TEXT_IO.fclose( v_file_d) ; EXCEPTION WHEN OTHERS THEN PESAN('Proses Upload Product Family Detail Selesai!!!') ; RETURN; END; Saya juga pernah buat form untuk upload file excel (csv file) tapi type kolomnya adalah character semua dan setelah saya copykan formnya ke oracle apps; data bisa ter-insert ke table oracle. Untuk kasus di atas, csv filenya adalah campuran antara character dan numerik. Saya kuatir untuk type numeriknya yang tidak pernah berhasil di-insert. gimana caranya yah...tolongin dong... Thanks atas bantuannya gt ____________ _________ _________ _________ _________ _________ _ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile. yahoo.com/ ;_ylt=Ahu06i62sR 8HDtDypao8Wcj9tA cJ [Non-text portions of this message have been removed] <!-- #ygrp-mkp{ border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;} #ygrp-mkp hr{ border:1px solid #d8d8d8;} #ygrp-mkp #hd{ color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;} #ygrp-mkp #ads{ margin-bottom:10px;} #ygrp-mkp .ad{ padding:0 0;} #ygrp-mkp .ad a{ color:#0000ff;text-decoration:none;} --> <!-- #ygrp-sponsor #ygrp-lc{ font-family:Arial;} #ygrp-sponsor #ygrp-lc #hd{ margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;} #ygrp-sponsor #ygrp-lc .ad{ margin-bottom:10px;padding:0 0;} --> <!-- #ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;} #ygrp-mlmsg table {font-size:inherit;font:100%;} #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;} #ygrp-mlmsg pre, code {font:115% monospace;} #ygrp-mlmsg * {line-height:1.22em;} #ygrp-text{ font-family:Georgia; } #ygrp-text p{ margin:0 0 1em 0;} #ygrp-tpmsgs{ font-family:Arial; clear:both;} #ygrp-vitnav{ padding-top:10px;font-family:Verdana;font-size:77%;margin:0;} #ygrp-vitnav a{ padding:0 1px;} #ygrp-actbar{ clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;} #ygrp-actbar .left{ float:left;white-space:nowrap;} .bld{font-weight:bold;} #ygrp-grft{ font-family:Verdana;font-size:77%;padding:15px 0;} #ygrp-ft{ font-family:verdana;font-size:77%;border-top:1px solid #666; padding:5px 0; } #ygrp-mlmsg #logo{ padding-bottom:10px;} #ygrp-vital{ background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;} #ygrp-vital #vithd{ font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;} #ygrp-vital ul{ padding:0;margin:2px 0;} #ygrp-vital ul li{ list-style-type:none;clear:both;border:1px solid #e0ecee; } #ygrp-vital ul li .ct{ font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;} #ygrp-vital ul li .cat{ font-weight:bold;} #ygrp-vital a{ text-decoration:none;} #ygrp-vital a:hover{ text-decoration:underline;} #ygrp-sponsor #hd{ color:#999;font-size:77%;} #ygrp-sponsor #ov{ padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;} #ygrp-sponsor #ov ul{ padding:0 0 0 8px;margin:0;} #ygrp-sponsor #ov li{ list-style-type:square;padding:6px 0;font-size:77%;} #ygrp-sponsor #ov li a{ text-decoration:none;font-size:130%;} #ygrp-sponsor #nc{ background-color:#eee;margin-bottom:20px;padding:0 8px;} #ygrp-sponsor .ad{ padding:8px 0;} #ygrp-sponsor .ad #hd1{ font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;} #ygrp-sponsor .ad a{ text-decoration:none;} #ygrp-sponsor .ad a:hover{ text-decoration:underline;} #ygrp-sponsor .ad p{ margin:0;} o{font-size:0;} .MsoNormal{ margin:0 0 0 0;} #ygrp-text tt{ font-size:120%;} blockquote{margin:0 0 0 4px;} .replbq{margin:4;} --> ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping [Non-text portions of this message have been removed]
