!  !-V  6AMWaiq{ -D.p/012384f56б⸦ Է ٽ ϴ.ڵ "%s"() ϴ.include ϴ.ȿ C Լ ο Ÿϰ Ÿ C Լ ϰ ȥǾϴC Լ ̸ մϴvoid Ű ֽϴ Լ 𿡴 ĺڰ 䱸˴ϴٺ Ű Դϴ Ű VARCHAR ͷ Ǿ մϴ 7J8o9:;<=;>T?q@AVARCHAR Ʈ ʵ带 ϴ.2 ʰϴ VARCHAR 迭 ʽϴ߸ VARCHAR Դϴ - ̰ Ǿϴٻ sizeof ǥ ϴ.ǥ ϴ. Ŀ Դϴٺ ijƮ ǥ Ǿϴ. ʽϴٻ Ŀ ùٸ ǿ ϴٵ Ͱ ⸸ ˴ϴ BPCpDEFGH I=J`K{LM ĺڰ ֽϴٽĿ typedef ̸ Ǿϴ ( ʿմϴ) ̸ typedef ̸ Ǿϴٺ ۾ ۾Դϴٱ Ǵ ͸ 䱸մϴǵ Դϴټ Լ Ͽϴ Ÿ ʿմϴǵ SQL ĺSQL ĺڸ Ϸ ߽ϴSQL ĺڰ ɹ ʾҽϴ NDOkPQRSTCUgVWSQL ĺڰ Ŀ ʾҽϴĿ ɹ ĺڰ ־ մϴȣƮ մϴش 迭 ϴ. ø Ǵ Ͼ Ե˴ϴȣƮ Ͼ ϴٱ Ʈ ʵ带 ϰ ֽϴȣƮ մϴFOR UPDATE Ŀ WHERE CURRENT OF մϴĿ ǽ̾ մϴ XDYZ[\ ]3^W_w`aȣƮ 迭 ũⰡ ġ ʽϴ. ּ ũ⸦ մϴ: %ld PL/SQL SQLCHECK=SEMANTICS ־ մϴPL/SQL ǹ ֽϴPL/SQL ֽϴEXEC IAF ڰ ʽϴ е Ǿ մϴ SQL Ÿ  ϴٺ  ԴϴPL/SQL ε ġ Ѿϴǹ %d, %d, %s ֽϴ:b8crdefg*h_i#include SQL ʰ ֽϴٺϰų ɼԴϴ%d , %d , %s Ͽ ֽϴ:Լ ȣ ȣƮ ν ʾƾ մϴARRAYLEN ĺڴ 迭 ̸ ־ մϴARRAYLEN ĺڴ 4-Ʈ ̾ մϴ 迭 Ÿ԰ ARRAYLEN Բ ϴ մϴARRAYLEN SQL ε 迭 Բ ϴj8ktlmn oDpnqȣƮ SQL DECLARE ȿ ʾҽϴ Ǿ־ մϴȣƮ ش ڴ ʵ ־ 迭 ũ ȣƮ 迭 ũ⺸ Ŀ մϴٸ μ MODE=ANSI DBMS=V6 Բ ϴ. short Ǿ EXEC TOOLS ȣƮ ̸ ƴմϴEXEC TOOLS ȣƮ Ͱ ƴմϴ rDsytuvwx0yfz{EXEC TOOLS MESSAGE ȣƮ Ÿ ƴմϴٺ FOR FOR SELECT 忡 ʽϴEXEC SQL DECLARE ǿ ԴϴSQLCHECK ɾ ʰ߽ϴSQL Լ ü ۿ ãҽϴDEF_SQLCODE = TRUE SQLCODE ϴپϽ varchar 迭 ʽϴٱ ŸԴϴٱ  ϴ |>~yAh йȣ 带 ϴ.NLS_LOCAL=YES ÿ MODE = ANSI ؾ մϴOCIExtProcContext ʿմϴٹ迭 ڰ Ǿϴ.NLS_CHAR NLS_LOCAL=TRUE CHAR_MAP ʽϴ.AT ⼭ ʽϴsql_cursor ʿմϴٹ迭 SELECT FROM/WHERE ʽϴٹ迭 SELECT Ͽ Է ε ʽϴ >aPEXEC SQL CONTEXT USE ϴ. ð Ȯ ƴմϴEXEC SQL DECLARE SECTION ̹  ֽϴSQL EXEC SQL DECLARE SECTION ȿ ãҽϴԷ ϸ ϸ Դϴٱ 迭 ̸ õ ʿմϴٱ 迭 ȿ 迭 ϴ ߸ ԴϴVARCHAR #include Ͽ ʽϴ 忡 ڰ õǾϴ >RDBMS=V6 CHAR_MAP ɼ Ʋϴ. ɼ õǾϴ.ȣƮ ؾ߸ մϴ ȣƮ 迭 ʽϴPro*C ɼ OBJECTS=YES ü ijø ʿմϴ ȣƮ մϴ Ǿ մϴٺ ǵ Դϴ'RETURN[ING] REF INTO :' ʿմϴٰü REF ġ ʽϴ >^}8aϺ ü ʿմϴϺ REF ʿմϴϺ ʿմϴ.INDICATOR ׸ ȣƮ ԴϴFOR OBJECT GET Ǵ SET ʽϴټӼ ȣƮ ġ ʽϴ ü Ӽ ʽϴ\r OBJECT GET Ǵ SET Object Ӽ ϴ.OBJECT GET Ǵ SET ִ ü 迭 ʾƾ մϴ8p?nѼӼ ȣƮ ̸ ȯϴµ Դϴٰü REF ȣƮ ̿ 迭 ũⰡ ġ ʽϴOBJECT SET Ǵ GET ȣƮ 迭 ʽϴٺҿ (Ǵ ) Ǿϴ ȣƮ ʿմϴ־ ɼǿ Ǿϴ ɼ ȣƮ ֽϴٰ ȣƮ ġ ʽϴ Dq%S Ӽ Ȱ ʿϴLOB ȣȯմϴټ ùٸ ڿ ƴմϴٹ LOB ȣȯԴϴϺ LOB ʿմϴϺ LOB ʿմϴٿܺ LOB (BFILE) ʿմϴREAD WRITE ܺ LOB(BFILE) ϴ. ȣƮ Ӽ ԴϴFOR  LOB ʾҽϴ >d:j Ӽ LOB մϴ Ӽ ܺ LOB (BFILE) մϴ ִ ʿմϴٸ ü 迭 ʽϴFOR COLLECTION ʾҽϴ Ӽ γ ܺ LOB մϴټӼ ȣƮ ġ ʽϴ 1 65535 ʿմϴ DYNAMIC=ANSI Ǿ մϴ >p)Nuܱ մϴUSING PREPARE մϴFOR DEALLOCATE ʾҽϴLOB WRITE APPEND ϴ.NLS_NCHAR ɼǿ UCS2 ϴ.UCS2  Է ϴĿ ̵ 忡 ABSOLUTE 忡 0 Ǵ Common SQL Front End ǹ ߽߰ϴ.8@pOUTLINE ɼ SQLCHECK=SEMANTICS(FULL) ɼ ؾ մϴ.OUTLINPREFIX ɼ OUTLINE ɼ ؾ մϴ.RUNOUTLINE ɼ OUTLINE ɼ ؾ մϴ.ƿ SQL ϴ.ƿ α ϴ.ƿ ̸ Ǵ ̸ ʰմϴ.ƿ ʰ߽ϴ.ƿ ϴ.