Çë½ÌjsÈçºÎ²Ù×÷oracleÊý¾Ý¿â - Web ¿ª·¢ / JavaScript
ÈçºÎÓÃjsÁ¬½ÓoracleÊý¾Ý¿â£¬´´½¨±í£¬Ìí¼ÓÊý¾ÝµÈ²Ù×÷£¬¾Ù¼¸¸ö¼òµ¥µÄjs´úÂëÀý×Ó¿´¿´£¿
JSÊǿͻ§¶ËµÄ¶«Î÷£¬Êý¾Ý¿âÊÇÔÚ·þÎñÆ÷¶ËµÄ¶«Î÷¡£
Èç¹ûÄãÏëÒªÓÃJS²Ù×÷Êý¾Ý¿â£¬ÄÇô£¬ÄãÐèÒªÔ¤ÏÈÔÚ·þÎñÆ÷¶Ë±àдºǫ́³ÌÐò£¬Õâ¸ö³ÌÐò¿ÉÄÜÊÇasp, php, javaµÈ£¬µ«²»ÊÇJS¡£È»ºóÒ³ÃæÀïͨ¹ýajax»òÕßÖ±½Óͨ¹ýÒ³ÃæµÄÌø×ª£¬È¥µ÷Óúǫ́³ÌÐòÀ´²Ù×÷Êý¾Ý¿â
JScript code:
var con = new ActiveXObject("ADODB.Connection");
con.open("Provider=OraOLEDB.Oracle;Source='';User ID='';Password='';PLSQLRset=1");
ÕâÑù¾Í¿ÉÒÔÁ¬½ÓÊý¾Ý¿â¶ÁÈ¡Êý¾ÝÁË
JSµÄÔ´´úÂëÒ»°ã±ðÈ˲鿴ԴÎļþ¾ÍÄÜ¿´µ½ÁË¡¡
Ö±½ÓÓÃÀ´²Ù×÷£¬»áºÜ±¯ÇéµÄ
¶øÇÒActiveXObjectµÄ¼æÈÝÐÔ¡Ò²»áÏ൱µÄ±¾ß
var con = new ActiveXObject("ADODB.Connection");
con.open("Provider=OraOLEDB.Oracle;Source='';User ID='';Password='';PLSQLRset=1");
wangfuxiang ÄãÓÃÕâÑùµÄajaxÁ¬½ÓÊý¾Ý¿âÂð£¿
ÔÚʵ¼ÊÏîÄ¿ÖÐÖ¸¶¨²»ÄÜÓÃjsÁ¬½ÓÊý¾Ý¿âÁË£¬°²È«ÐÔÎÊÌâ°¡£¡µ«ÊÇÕâÖÖ·½·¨È·ÊµÊÇ¿ÉÒÔÁ¬½ÓÊý¾Ý¿âµÄ¡£
4Â¥µÄÈç¹û¸ÒÐËȤ¿ÉÒÔ³¢ÊÔÏ£¬ËÙ¶ÈÒ²Âù¿ìµÄ¡£
aspµÄ»° Óà jscriptд·þÎñÆ÷ Á¬ oracle°¡
Ò»°ã²»ÓÃÕâ¶«Î÷²Ù×÷Êý¾Ý¿âµÄ°É¡£¡£
ÓÃ ActiveXObject
µÄ»°»ðºü ²»¼æÈÝ
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
Ö÷ÒªÏëʵÏÖ£ºÔÚÿÌìµÄ0µã֮ǰ×Ô¶¯½«Êý¾Ý²åÈëÊý¾Ý¿â£¬Ï£Íû´ó¼ÒÖ¸µã£¡
×Ô¶¯²åÈë?Êý¾ÝÔ´ÄÄÀïÀ´µÄ,²åÈ뵽ʲôµØ·½
´¥·¢Æ÷?
Ó¦¸ÃÓÃJOB
Êý¾ÝÔ´ÔÝʱÏëµÄÊǹ̶¨Êý¾Ý£¬²åÈëµ½Ò»Õűí
ÄǾÍÊÇÓÃJOB¶¨Ê±Ö´ÐÐ,´ÓÎļþµ¼ÈëÊ ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test
as
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......