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

oracle ɾ³ý±í

ÔÚ´æ´¢¹ý³ÌÀïÔõôɾ³ý±í£¬ÎÒʹÓãº
drop table MV_AREA_TID_LOTTERY_DAY_TMP;
ÕâÓï¾ä£¬µ«±¨
Compilation errors for PACKAGE BODY OMAS.PKG_PROCIMPORTDATA

Error: PLS-00103: Encountered the symbol "DROP" when expecting one of the following:

:= . ( @ % ; immediate
Line: 87
Text: execute drop table MV_AREA_TID_LOTTERY_DAY_TMP;



ÔõôÑùÔÚ´æ´¢¹ý³ÌÀïɾ³ýÒ»¸ö±í£¬³ýÁËʹÓÃexecute immediate 'drop table MV_AREA_TID_LOTTERY_day_TMP'; ûÆäËü°ì·¨ÁËÂð£¿
ʹÓÃexecute immediate 'drop table MV_AREA_TID_LOTTERY_day_TMP'ÓÐʲôÎÊÌâÂð£¿

Oracle 8i ¼°ÒÔÉϰ汾ÖУ¬»¹ÄÜÓà DBMS_UTILITY.EXEC_DDL_STATEMENT(ddl_sql_str) Ö´ÐÐ DDL Óï¾ä¡£
µ«ÊÇÎÞÂÛÄÄÖÖÇé¿ö£¬ÄãµÄPACKAGE BODY±àÒëδͨ¹ý£¬¸ù±¾ÎÞ·¨Ö´ÐС£Ê×ÏÈÐèҪͨ¹ý±àÒ룬ȻºóÔÙÖ´ÐС£¡£

ddlÔÚprocedureÖ»Äܶ¯Ì¬sql¡£

plsqlµÄ³ÌÐò¿é£¬±ÈÈçprocedureºÍtriggerÊDz»ÄܼÓÈëddlÓï¾äµÄ£¬Èç¹ûÓÐddlÓï¾ä£¬ÊÇÓбàÒë´íÎó¡£

µ«ÊÇoracleÌṩÁËexecute immediateÕâÑùµÄ¶¯Ì¬sqlµÄ¹¦ÄÜ¡£

ÓÃÁËexecute immediateÓï¾ä£¬Ôõô±£Ö¤Ö´ÐеÄ˳ÐòÄØ


ÒýÓÃ
ÒýÓÃÂ¥Ö÷ pdw2009 µÄ»Ø¸´:
ÔÚ´æ´¢¹ý³ÌÀïÔõôɾ³ý±í£¬ÎÒʹÓãº
drop  table  MV_AREA_TID_LOTTERY_DAY_TMP;
ÕâÓï¾ä£¬µ«±¨
Compilation errors for PACKAGE BODY OMAS.PKG_PROCIMPORTDATA

Error: PLS-00103: Encountered the symbol "DROP" when expecting one of the following:
     
       


Ïà¹ØÎÊ´ð£º

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Ò²²»¿É ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......

eclipseÖÐÁ¬½ÓoracleµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨
ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off cli ......

javaµ÷´æ´¢¹ý³Ì - Oracle / »ù´¡ºÍ¹ÜÀí

´æ´¢¹ý³Ì£º
create or replace procedure insert_emp
 (empid in number,
 empname in varchar2,
 empsal in number)
 as
 begin 
  insert into emp(empno,ename ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ