#  -j 7BNWbkt -J.u/012 3#4E5e67ԴԹصҹաԴҵصҧ "%s" ԴѺûСȿѧѹ C ١ͧҼͧûСȿѧѹ C Ẻ١ͧͿѧѹ C ١ͧ¡ԡ㹢ǵͧ ID 㹡ûСȿѧѹûСȾẺ١ͧẺ VARCHAR ûС繾տŴԵ VARCHAR 8J9t:;<=%>M?j@AB VARCHAR ҡ 2 ѹûС VARCHAR ٻẺ١ͧ - кؤǻԹҴҤͧ硫ʪѹԹ硫ʪѹ繤Ҥ硫ʪѹҤ١ͧ硫ʪѹͧá˹١ͧ硫ʪѹ١ͧ硫ʪѹçѺԾҧԵʵջͧ·١ͧź੾о 2 ҹ鹾 ID ˹ CPDEFGHI+JWK}LMN󾺪 typedef 硫ʪѹ (ͧä)͵÷繪 typedef÷ӧҹẺշȷҧ١ͧ÷ӧҹҧԧçҧ١ͧͧçҧ;ͧçҧ˹ҪԡçҧҧԧѺѧѹѧСȤҴ硫ʪѹ繻ӹǹ˹ ID ͧ SQLС˹ ID ͧ SQL С ID SQL 繤С ID SQL O>PmQRSTU+VHWҢͧͧաõ駪 ID 硫ʪѹͧʵջ١ͧСѹѺçҧçҧ͡͹ѹʵ繻çҧտŴԵʵջ١ͧ WHERE CURRENT OF ˹ǹͧ FOR UPDATEҢͧͧ硫ʪѹ׺ XJYZ[\]^6_R`sabҴͧʵçѹ Ҵش: %ldͧк SQLCHECK=SEMANTICS ͤ PL/SQL 㹾ͼԴҴҹҢͧ PL/SQLͼԴҴͧٻẺ PL/SQLǺ觪㹤 EXEC IAF ͧкطȹͧºһ SQL ºһ١ͧ˹觡亹͡ͺࢵҡ PL/SQLԴͼԴҴͧҷ÷Ѵ %d %d %s: #include դ SQL c>dwefgh6i^jkѵ͡١ͧѹ кżž͹÷Ѵ %d %d %s: ¡ѧѹ硫ʪѹͧʵID ARRAYLEN ͧ繪ͧ͢ID ARRAYLEN ͧ繨ӹǹҴ 4 亵Ѻ ARRAYLEN к ARRAYLEN 亹ͧ SQLСȵʵǹ SQL DECLAREú觪ͧçҧ l>mrnop qDr~stçҧеǺ觪ͧʵͧըӹǹŴҡѹҴͧǺ觪ͧ¡ҢҴͧʵ MODE=ANSI ͧ÷Ѵ觡Ѻ DBMS=V6 ͧСȵú觪 type shortͤ͹硫ʵ EXEC TOOLS ѡê͵þͧʵ EXEC TOOLS ʵ EXEC TOOLS MESSAGE ѡǹͧ FOR ١ͧǹͧ FOR 㹤 SELECT uDvowxyz {2|Y~ûСǹ EXEC SQL DECLARE ١ͧ SQLCHECK ҡҤҺ÷Ѵ觾 SQL ͡ҢͧѧѹسС SQLCODE DEF_SQLCODE = TRUEͧ varchars ͹ѡһШӪҵ١ͧºҵѡһШӪҵкաʼҹͧسͧк MODE=ANSI NLS_LOCAL=YESҴ硫ʪѹ繻 OCIExtProcContext DZHh ID CHAR_MAP NLS_CHAR NLS_LOCAL=TRUEǹͧ AT ͧ硫ʪѹ sql_cursor ͧǹͧ FROM/WHERE ͧ SELECT 繵亹ͧԹصʵ SELECT 辺 EXEC SQL CONTEXT USEä͹硫ѹջ١ͧس EXEC SQL DECLARE SECTION Ǿ SQL EXEC SQL DECLARE SECTION >`S}Թصҵص͹ѹͧçҧժͧ͡çҧ١ͧС VARCHAR #include кżŵǺ觪㹤觹ջҵ͡ CHAR_MAP Ѻ DBMS=V6 ١ͧ кżŵͧ͡Сȵʵ繻ѧʵͧ㹻Ѩغѹͧ OBJECTS=YES ͧ͡ Pro*C ᤪͧͺਡ >k<]Ȼú觪ͧʵ١ͧͧСȵú觪繻㹻§˹ҤҴҵͧٻẺ 'RETURN[ING] REF INTO :' ҹ鹻ͺਡ REF çѹҴ硫ʪѹ繻ͺਡҴ硫ʪѹ繻 REFҴ硫ʪѹ繻红ŻѺʵ¡ Descriptor ͧ INDICATOR ١ͧ8w=rǹͧ FOR 㹤 OBJECT GET OBJECT SET ӹǹͷԺçѺӹǹʵͷԺǹͺਡкبѴͷԺͺਡ㹤 OBJECT GET OBJECT SET ͺਡ㹤 OBJECT GET OBJECT SET ͧŧҧͷԺеʵ١ͧҴͧʵͺਡ REF çѹʵ㹤 OBJECT SET OBJECT GET Jn7Ky͡˹ó ()ʵͧú觪ҷкѺ͡͹硫١ͧʵջѺҵ͡ӹǹеʵçѹͧú觪ѺͷԺǹ LOB 硫ʪѹʵԧѡз١ͧѿѺ LOB Ҵ硫ʪѹ繻 LOB 㹤Ҵ硫ʪѹ繻 LOB Ш >mFuΤҴ硫ʪѹ繻 LOB (BFILE) Դ LOB (BFILE) ¹͡ READ WRITEʵͷԺ١ͧǹͧ FOR 㹤 LOB ͷԺǹѺ LOB ҹͷԺǹѺ LOB ¹͡ (BFILEs) ҹ鹤Ҵ硫ʪѹ繻ӹǹẺ亹ͧͺਡ红ǹͧ FOR 㹤 COLLECTION >o)gͷԺǹѺ LOB ¹͡ҹ鹨ӹǹͷԺçѺӹǹʵҴҤҧ 1 65535Ըաùк DYNAMIC=ANSI ǤҼͧǹͧ觷 Descriptor Descriptor ١ͧǹͧ USING ѺẺ䴹Ԥ PREPARE ҹǹͧ FOR 㹤 DEALLOCATE кͿ絻·ҧ LOB WRITE APPEND кص UCS2 㹵͡ NLS_NCHAR >X,fºһ UCS2 С͹ͿèѴҧ ABSOLUTE 繤źCommon SQL Front End ͼԴҴǡѺٻẺҵͧ͡ SQLCHECK=SEMANTICS(FULL) ա͡ OUTLINEͧ͡ OUTLINE ա͡ OUTLINPREFIXͧ͡ OUTLINE ա͡ RUNOUTLINEöԴ SQL ͧҵŹöԴͧ͡ҵŹHbyǢͧҵŹԹմӡѴ˹ӹǹҵŹԹմӡѴöҧҵŹ