oracle´æ´¢¹ý³Ì±àдµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
±¾È˸ոսӴ¥´æ´¢¹ý³Ì·½ÃæµÄÉè¼Æ£¬ÔÚ±àдµØ·½²»Ì«¶®¡£ÎÒÏÖÔÚµÄÇé¿öÊÇÕâÑùµÄ£ºÎÒ´´½¨ÁËÒ»¸ö´æ´¢¹ý³Ì×ֶδúÂëÈçÏÂ
(
plateid in Varchar2,
platecolor in Varchar2,
platetype in Varchar2,
crossingtime in Date,
crossingname in Varchar2,
aspectname in Varchar2,
wayname in Varchar2,
speed in Varchar2,
illegaltype in Number,
blackstate in Number,
filepath1 in Varchar2,
filepath2 in Varchar2,
filepath3 in Varchar2,
filepath4 in Varchar2,
result_blackstate out Number£¬
result_plateid out Number
)
as
begin
commit;
end;
ÐèÒª²åÈëÒÔÉÏ×ֶεıíÃûΪ£º
tb_plate;tb_illegalcar;tb_normalcar
ÐèÒª¿¼ÂǵÄÎÊÌ⣺
1£ºplateid,platecolor,platetype£»Õâ3¸ö×Ö¶ÎÒª·ÅÈë±ítb_plate£¬¶øÇÒ±íÀïµÄplateidÓÐÎ¨Ò»Ô¼Êø£¬Èç·¢ÏÖÏàͬÊý¾Ý·µ»Ø1¡£·µ»ØµÄ×Ö¶ÎÊÇresult_plateid¡£
2£ºcrossingtime,crossingname,aspectname,wayname,speed,illegaltype,filepath1,filepath2,filepath3,filepath4£»ÕâЩ×Ö¶ÎҪͬʱ²åÈëµ½tb_illegalcarºÍtb_normalcarÁ½±íµ±ÖвåÈëÕâ2±íµÄÅжÏÌõ¼þÊÇ£ºµ±illegaltype=1ʱ²åÈëµ½tb_normalcar£¬µ±illegaltype=ÆäËûÊý×Öʱ²åÈëµ½tb_illegalcar±íÀï¡£
3£ºÔÚ²Ù×÷2Öл¹ÒªÅжÏblackstateµÄÖµ£¬Èç¹ûblackstate=1ÄÇôµ±Ç°ÐÅÏ¢²åÈëµ½tb_normalcar±íÀblackstate=2ÄÇôµ±Ç°ÐÅÏ¢²åÈëµ½tb_illegalcar£¬blackstate=3ÄÇôÉáÆúÕâÌõÐÅÏ¢¡£
4:2ºÍ3µÄÅжÏÌõ¼þÊDz¢ÁдæÔڵġ£¶¼ÐèҪȥÅжϡ£
ÒòΪ¿¼Âǵĵط½ºÜ¶à£¬ÐèÒªÅжϵÄÒ²ºÜ¶à¡£µ«ÊÇbeginºÍendÖмäÔõôдÎÒ»¹ÊµÔÚ²»Ì«»á¡£Ï£ÍûµÃµ½½â´ð.
Ìõ¼þÅжÏÓï¾ä£
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......