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

ÇóÖúoracle±¨´í -1002 - Oracle / »ù´¡ºÍ¹ÜÀí

EXEC SQL DECLARE Cur_TranRec CURSOR for
SELECT MessType,Account,TranAmount,TranNum,ClientTime,ClientDate,IdenCode,PosCkNum,ResePrivate,DevID,POSScNum
from PosTranRec
WHERE MessType ="0200"
ORDER BY ClientDate;
if(SQLCODE){
printf("Error declare Cur_TranRec SQLCODE=[%d]\n",SQLCODE);
return -1;
}
EXEC SQL OPEN Cur_TranRec;
while(1){
EXEC SQL FETCH Cur_TranRec INTO
:spMsgType,:spAccountNo,:spTranAmt,:spClientTraceNum,:spClientTime,:spClientDate,:spAcqID,:spPOSCkNum,:spBatchNo,:spDevID,:spPOSScNum;
printf("%s\n%s\n%s\n%s\n%s\n%s\n%s\n%s\n%s\n%s\n%s\n \n",spMsgType,spAccountNo,spTranAmt,spClientTraceNum,spClientTime,spClientDate,spAcqID,spPOSCkNum,spBatchNo,spDevID,spPOSScNum);
if(sqlca.sqlcode ==1403){
printf( "ERROR FETCH Cur_TranRec SQLCODE[%d]\n",SQLCODE);
EXEC SQL CLOSE Cur_TranRec;
break;
  }
else{
if(sqlca.sqlcode != 0){
printf( "ERROR FETCH Cur_TranRec SQLCODE[%d]\n",SQLCODE);
EXEC SQL CLOSE Cur_TranRec;
TSPDbclose();
break;
}
}


±¨´í1002 ÇóÖúÁË{{


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

Oracle ¸ßÊÖ½ø - Java / Java EE

SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from t_out_logon) A WHERE ROWNUM <= 30)WHERE RN >= 21
SELECT A.* from (SELECT t.*,rownum rn from t_out_logon t WHERE ROWNUM <= 30) A WHERE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ