Solaris10ãOracle10ã®ç°å¢ã§ãã Pro*Cã§ã³ã³ãã¤ã«ãè¡ãçºã®åèmakefileã¨æããã $ORACLE_HOME/precomp/demo/proc/demo_proc.mk ãªã©ã®ãã¡ã¤ã«ãããã¾ããã demo_proc.mkã¯ãµã¼ãã¼ä¸ã®ã©ãã«ãããã¾ããã 調ã¹ã¦ã¿ãã¨ãã©ãããOracleã®CompanionCDã®ä¸ã« å ¥ã£ã¦ããããã§ãã(ï¼)ãCDãããã®ãã¡ã¤ã«ãåå¾ããäºã¯ å¯è½ã§ããããï¼ ï¼ä»æå ã«CDãç¡ãã®ã§ãããå¾æ¥åå¾äºå®ã§ãï¼ åºæ¥ãã°ããã¡ã¤ã«ã ãåå¾ãã¦ã ã¤ã³ã¹ãã¼ã«ãç°å¢çã¯å¤ãããããã¾ããã ãã®ãããªäºãå¯è½ã§ããããï¼
Oracle DatabaseWorld ã®å ¨ã»ãã·ã§ã³åç»ãæ¥æ¬èªåå¹ä»ãã«ã¦è¦è´ããã ãã¾ããèªç¶è¨èªã«ããååããAIãã¯ãã«æ¤ç´¢ãTrue Cache, JSON Duality, OCI GoldenGate Stream, GoldenGate 23ai, SQL Firewall, 23aiã®é«å¯ç¨æ§ããªã©æ§ã ãªãããã¯ãæ±ã£ã¦ãã¾ãã
10 ããªã³ã³ãã¤ã©ã®ãªãã·ã§ã³ ãã®ç« ã§ã¯ãPro*C/C++ããªã³ã³ãã¤ã©ã®å®è¡æ¹æ³ã¨ããªã³ã³ãã¤ã©ã»ãªãã·ã§ã³ã®æ¡å¼µã»ããã«ã¤ãã¦è©³ãã説æãã¾ãããã®ç« ã®é ç®ã¯ã次ã®ã¨ããã§ãã ããªã³ã³ãã¤ã©ã®ã³ãã³ã ããªã³ã³ãã¤ã©ã®ãªãã·ã§ã³ ã¯ã¤ãã¯ã»ãªãã¡ã¬ã³ã¹ ãªãã·ã§ã³ã®å ¥å ããªã³ã³ãã¤ã©ã»ãªãã·ã§ã³ã®ä½¿ç¨ ããªã³ã³ãã¤ã©ã®ã³ãã³ã ããªã³ã³ãã¤ã©ã®ä½ç½®ã¯ã·ã¹ãã ã«ãã£ã¦ç°ãªãã¾ããã·ã¹ãã 管çè ã¾ãã¯ãã¼ã¿ãã¼ã¹ç®¡çè ã¯ãé常ã¯è«çåã¾ãã¯ã¨ã¤ãªã¢ã¹ãæå®ãããããã®ä»ã®ã·ã¹ãã åºæã®æ段ã使ç¨ãã¦ãPro*C/C++å®è¡ãã¡ã¤ã«ãã¢ã¯ã»ã¹å¯è½ã«ãã¾ãã Pro*C/C++ããªã³ã³ãã¤ã©ãå®è¡ããã«ã¯ã次ã®ã³ãã³ããå ¥åãã¾ãã proc option=value... ãã¨ãã°æ¬¡ã®ã³ãã³ããå ¥åããã¨ãã¾ãã proc INAME=test_proc ã«ã¬ã³ãã»ãã£ã¬ã¯ããªã®ã
Oracle DatabaseWorld ã®å ¨ã»ãã·ã§ã³åç»ãæ¥æ¬èªåå¹ä»ãã«ã¦è¦è´ããã ãã¾ããèªç¶è¨èªã«ããååããAIãã¯ãã«æ¤ç´¢ãTrue Cache, JSON Duality, OCI GoldenGate Stream, GoldenGate 23ai, SQL Firewall, 23aiã®é«å¯ç¨æ§ããªã©æ§ã ãªãããã¯ãæ±ã£ã¦ãã¾ãã
Oracle11gï¼11.1.0.7ï¼ã§Pro*C ãããªã³ã³ãã¤ã«ãã¦ã¿ãã $ cd /export/home/oracle/app/oracle/product/11.1.0/db_1/precomp $ mkdir demo $ cd demo $ vi sample1.pc # ã½ã¼ã¹ã³ã¼ãã¯ä¸è¨åç § $ proc include=$ORACLE_HOME/precomp/public include=. iname=sample1.pc oname=sample1.c $ ls ample1.c sample1.lis sample1.pc sample1.pc ã Oracle ã®ããã¥ã¢ã«ããã³ãã¼ããã½ã¼ã¹ã³ã¼ããsample1.c ã¯ããªã³ã³ãã¤ã«ãã¦çæãããã½ã¼ã¹ã³ã¼ãã sample1.pc /* * sample1.pc * * Prompts the user
ããã¾ããã C:\oracle\ora92\precomp é ä¸ã§ãã å²ã込㿠!! proCã使ã£ãããã¸ã§ã¯ãã®ã³ã³ãã¤ã«ãéããªãã£ã¦äºããã£ããåå ã¯ãããªã³ã³ãã¤ã«ãããã¨ãã«ãå®éã«ãªã©ã¯ã«ã®ãã¼ãã«ã¾ã§ã¢ã¯ã»ã¹ãã«è¡ãããã§ãã ã ããããªã©ã¯ã«ã¨ã®æ¥ç¶ã確ç«ããã¦ãã¦ããªããã¤ã使ç¨ãããã¼ãã«ãªã©ãç¡ãã¨ãã¡ãããã§ã⦠2004/07/16 ã§ã¯ãSAMPLE8 æå®ããé¨éã®å ¨å¾æ¥å¡ã®ååãemp 表ããåå¾ãã¾ãï¼åçSQL æ¹æ³3ï¼ã ãªããã²ã¨ã¤ãã£ã¦ã¿ã¾ããããã ã³ã³ãã¤ã«ã®æ¹æ³ã¯VC++ã§è¡ãªãæ¹æ³ãããã¿ããã ããç°¡åãããªã³ãã³ãã¹ã¯ãªãããããã§è¡ããï¼ ã©ãããç°å¢å¤æ°ãããè¦ãããVisualStudioãããã¨ããã£ã¦ãããã§ããã®ããªï¼ ããã¨ããªã©ã¯ã«ãã¼ã ãè¨å®ãã¾ããããããããã·ã¹ãã å´ã«ãã¦ããã¾ããã ã³ãã³ãã©ã¤
åå ¸æ å ±: $ORACLE_HOME/precomp/doc/proc/readme.doc ç®æ¬¡ 1 äºææ§ã¨ç§»è¡ã®åé¡ç¹ 2 æ°æ©è½ 3 Pro*C/C++ãªãªã¼ã¹10.1.0.2.0ã®æ¢ç¥ã®ä¸å ·å 4 ãã®ãªãªã¼ã¹ã§ä¿®æ£ãããä¸å ·å 5 Pro*C/C++ 10.1.0.2.0ã®å¶éäºé 6 Pro*C/C++ 8.1.6ã®å¶éäºé 7 ãPro*C/C++ Precompiler ããã°ã©ãã¼ãºã»ã¬ã¤ããã®è£è¶³äºé 8 ãã®ä»ã®åé¡ 1 äºææ§ã¨ç§»è¡ã®åé¡ç¹ 1.1 V6äºæåä½ã®ãµãã¼ãã®ä¸æ¢ Oracle7ã«ã¯ãOracle7ã¢ããªã±ã¼ã·ã§ã³ãéçºããã¢ããªã±ã¼ã·ã§ã³éçºè ãOracle6ã®åä½ãã¨ãã¥ã¬ã¼ãã§ããããã«ããã¼ã¸ã§ã³6[V6]äºææ§ãã©ã°ãç¨æããã¦ãã¾ãããOracleãªãªã¼ã¹8.0.3ããã¯ããã¹ã¦ã®Oracle8製åï¼PL/SQL8ããã¹ã¦ã®Oracleã
Windows OSã«ã¯Cã®ã³ã³ãã¤ã©ãæ¨æºã§ä»å±ãã¦ããªãããPro*Cããã°ã©ã ã®ã³ã³ãã¤ã«ã«ã¯VC++çã®ã³ã³ãã¤ã©ã®ã¤ã³ã¹ãã¼ã«ãå¿ è¦ã§ãã æ¬ãã¼ã¸ã§ã¯VC++ä»å±ã®ã³ã³ãã¤ã©(cl.exe)ã使ã£ãORACLEã®ãã¢ããã°ã©ã ã®ã³ã³ãã¤ã«æ¹æ³ãè¨è¼ãã¾ãã ç°å¢ ãã®æé ãå®è¡ããç°å¢ã¯ä»¥ä¸ã®éãã§ã ã³ã³ãã¤ã«æé æç·é¨ã¯ORACLE_HOMEãVisual Studioã®ãã¼ã¸ã§ã³ãDBã®æ¥ç¶æ å ±ã®ããç°å¢ã«å¿ãã¦å¤æ´ãã¾ãã ç°å¢å¤æ°è¨å® E:\proc_test>set ORACLE_HOME=E:\oracle\product\10.2.0\db_1 E:\proc_test>set MSVCDIR=C:\Program Files\Microsoft Visual Studio 9.0 E:\proc_test>set path=%ORACLE_HOME%\bin
Pro*Cã¨ã¯Cè¨èªãC++ã§ORACLEã«æ¥ç¶ããã¢ããªã±ã¼ã·ã§ã³ãä½æããçºã«ä½¿ç¨ããããã«ã¦ã¨ã¢ã§ãã Pro*Cã¯JDBCãOO4Oã¨ãã£ãããã«ã¦ã¨ã¢ã®ããã«ç´æ¥ãã¼ã¿ãã¼ã¹ã¸æ¥ç¶ããAPIãæä¾ãã¦ããã®ã§ã¯ãªãã Pro*Cç¬èªã®ã½ã¼ã¹ãprocã³ãã³ãã«ããCè¨èªã®ã½ã¼ã¹ã«å¤æ(ããªã³ã³ãã¤ã«)ãããã®ã½ã¼ã¹ãCã®ã³ã³ãã¤ã©ã§ã³ã³ãã¤ã«ãããã¨ã§å®è¡å¯è½ãªããã°ã©ã ãä½æããä»çµã¿ã¨ãªã£ã¦ãã¾ãã ã¤ã¾ããã½ã¼ã¹ãã¡ã¤ã«ããå®è¡å¯è½ãã¡ã¤ã«ãä½æããã¾ã§ã«ã¯ä»¥ä¸ã®ãããªå¤æãè¡ããããã¨ã«ãªãã¾ãã 1 Pro*C/C++ ç¬èªã®ã½ã¼ã¹(æ¡å¼µåã¯.pcãä¸è¬ç) â Pro*Cã«ãã£ã¦ããªã³ã³ãã¤ã« 2 Cè¨èªãC++ã®ã½ã¼ã¹(æ¡å¼µåã¯.cã.cppãä¸è¬ç) â ã³ã³ãã¤ã©ã«ãã£ã¦ã³ã³ãã¤ã« 3 å®è¡å¯è½ãã¡ã¤ã« Pro*Cã®ä½¿ç¨ã«ã¯Oracle Programerã©ã¤ã»
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}