Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

websphereÔÚoracleÈ¡Êý¾ÝÎÊÌâ

ÕâÊÇÔÚCompute½ÚµãÉϵÄESQL´úÂ룬ÇÒÊý¾ÝÔ´ÒѾ­Ð´ÉÏ£¬Í¬Ê±Ò²ÔÚ´úÀíÉÏÉèÖÃÁËmqsisetdbparms SITBRK -n MBAPP -u MBAPP -p MBAPP£¬
CREATE COMPUTE MODULE Exe4_Compute_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
-- ±¾Ä£¿é½«Ê×Ïȸ´ÖÆÏûϢͷ£¬²¢ÔÚ·ÃÎÊÊý¾Ý¿â±íCUSTOMERµÄ»ù´¡ÉÏ
-- ÖØÐ¹¹ÔìÊä³öXMLÏûÏ¢£¬Ìí¼ÓÒ»¸öеÄ×Ö¶Îname

-- Ê×Ïȸ´ÖÆÏûϢͷ
DECLARE I INTEGER 1;
WHILE I < CARDINALITY(InputRoot.*[]) DO
SET OutputRoot.*[I] = InputRoot.*[I];
SET I = I+1;
END WHILE;

-- ·ÃÎÊÊý¾Ý¿â±í¸ñcustomerµÃµ½Óëxml×Ö¶Îid¶ÔÓ¦µÄÓû§Ãû³Æ£¬²¢È¥µô¿Õ¸ñ
DECLARE TEMP CHAR;
SET TEMP = THE(SELECT ITEM T.CUST_NAME from Database.CUSTOMER AS T WHERE T.CUST_ID = InputRoot.XML.record.id);
SET TEMP = TRIM(BOTH ' ' from TEMP);

-- ¹¹ÔìÊä³öxmlÏûÏ¢
SET OutputRoot.XML.record.id = InputRoot.XML.record.id;
SET OutputRoot.XML.record.name = TEMP;
SET OutputRoot.XML.record.address = InputRoot.XML.record.address;
SET OutputRoot.XML.record.amount1 = InputRoot.XML.record.amount1;
SET OutputRoot.XML.record.amount2 = InputRoot.XML.record.amount2;
       
                  RETURN TRUE;
END;
END MODULE;


²¿ÊðʱûÓÐÎÊÌ⣬¿ÉÔÚ²âÊÔʱ£¬¸ù±¾Ã»ÓнøÈëµ½Computer½ÚµãÖ±½ÓcatchÁË£¬¾ÍÊÇ·ÅÈëÏûÏ¢ºó£¬Ö±½Ó´ÓFailure³öÀ´ÁË£¬Çë½


Ïà¹ØÎÊ´ð£º

Ë­ÄÜÍÆ¼ö¼¸±¾oracleµÄÊé»òÊÓÆµ - Oracle / ·Ç¼¼ÊõÇø

лл
ÎÒÒ²ÊÇÏëÖªµÀ

me too

ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ 
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......

¸öÈ˾õµÃÔ­ÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½Ì ......

linuxÏÂCÓïÑÔ¿ª·¢oracleµÄÎÊÌâ¡£

Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â 
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......

Á¬½ÓoracleÒì³£

·þÎñÆ÷ϵͳÊÇxp,Êý¾Ý¿âoracle10g£¬web·þÎñÆ÷ÊÇtomcat£¬Á¬½ÓÊý¾Ý¿âʱ±¨Á¬½Ó´íÎó£¬ÈçÏÂËùʾ£ºThe Network Adapter could not establish the connectionÒì³££¬oracle·þÎñºÍ¼àÌýÒѾ­ÆðÀ´ÁË£¨¶øÇÒ¶¼ÊÇÕýÈ·µÄ£©¡£Êý¾Ý¿âjar ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ