!  - <MZgr-h./01234 5!637V8k9:;<޷´Ҫȡļ޷򿪴ļ "%s"޷򿪰ļЧ C ˵Ƿ¾ C ͺ˵Ƿ C ֻеʱʹ voidڴ˺˵ҪʶǷʽ˵ʽ VARCHAR ӦΪָ˵ VARCHAR λֶβ 2 ά VARCHAR VARCHAR ˵ĸʽȷ - ȱٳ޷ʽijС޷ʽΪֵʽгַǷ=n>?@ABCD&EAFOGaHsIJKLMǷ cast ͱʽȱͱʽʽ÷ʽûȷIJָֻ֮ҵδıʶڱʽʹ typedef (Ҫҵһֵ) typedef ıǷļӲǷĽṹòҪṹṹָδĽṹԱδ˵Ҫһͱʽδ SQL ʶض SQL ʶûн SQL ʶΪһ˵ NVOwPQRSTUV%W\XxYZûн SQL ʶΪα˵αʶʽЧ޷˵͵ĶάṹаһǶ׽ṹ union union ͽṹһλֶзǷͶδʹ FOR UPDATE Ӿ䶨αʹ WHERE CURRENT OFαһѯʽСƥ䡣ʹСС: %ldʹǶʽ PL/SQL ʱ,ָ SQLCHECK=SEMANTICSPL/SQL [V\i]^_`abc8dPexfgPL/SQL ﷨EXEC IAF вָʾڴͱָ޷ͬ SQL ͷǷ͵ͬPL/SQL λó˽ڵ %d , %d , ļ %s : #include ļвܰ SQL Ч߷ѡ, Ծڵ %d , %d , %s ļ: òΪʽʹARRAYLEN ıʶһָ ARRAYLEN ıʶһ 4 λ hJitjklmn'oSpqqr ARRAYLEN һʹʱЧ SQL һʹʱ, ARRAYLEN ᱻδ SQL DECLARE ֽ˵ָʾһṹṹָʾֶָͬʾСССв MODE=ANSI DBMS=V6 һʹָʾΪ˵һ EXEC TOOLS ַһ EXEC TOOLS ָһָʾһ EXEC TOOLS MESSAGE ַ sVteuvwxyz{4|N~l̷Ƿ FOR ӾSELECT в FOR ӾEXEC SQL DECLARE ֳЧ˵SQLCHECK ֵеֵں֮ⷢ SQL DEF_SQLCODE = TRUE ʱ˵ SQLCODE֧ʽ varchars ڱַķǷ޷ͬڱַûʱ޷ָģʽʹ NLS_LOCAL=YES ʱָ MODE=ANSIԤΪ OCIExtProcContext ıʽȱ鳤˵ P?[}ʹ NLS_CHAR NLS_LOCAL=TRUE ʱ CHAR_MAP˴ʹ AT ӾҪһΪ sql_cursor ıʽ SELECT FROM/WHERE Ӿвʹ SELECT бвΪӱδκ EXEC SQL CONTEXT USE ʱͲȷѾ EXEC SQL DECLARE SECTION EXEC SQL DECLARE SECTION з SQL ļļͬʹýṹҪǸýṹڽṹڷǷʹ Pr4V|#include ļв VARCHAR ˵͵ָʾڸб DBMS=V6 Ƿ CHAR_MAP ѡֵѡԡ뽫Ϊָͽ˵͵鵱ǰ֧ʹöٻʱ, Ҫ Pro*C ѡ OBJECTS=YESڴЧָʾͱ뽫ʶΪָͽ˵δͱֻҪ 'RETURN[ING] REF INTO : ' REF ͲƥҪij͵ıʽ Pi+VvҪij REF ͵ıʽҪΪ Collection ıʽINDICATOR ЧOBJECT GET SET в֧ FOR ӾԲָĶ OBJECT GET SET ޷ OBJECT GET SET еĶһתϷ REF ֮Сƥ OBJECT SET GET в鲻 (ȱ) ˵b~/HaҪʹָʾΪѡָЧֵһԴѡֵЧֵıŲƥԲҪָʾLOB ͲݱʽַͲȷ LOB ͲҪڲ LOB ͵ıʽҪ LOB ͵ıʽҪⲿ LOB (BFILE) ͵ıʽ޷ READ WRITE ʽ´ⲿ LOB (BFILE)ЧԶLOB вʹ FOR Ӿֻڲ LOB Ps'Ie׸ֻⲿ LOB (BFILE)Ҫͱʽʹռ COLLECTION вʹ FOR ӾԶڲⲿ LOB ЧֵΧ 1 65535 ֮ ( 1 65535)ָֻ DYNAMIC=ANSI ʱ÷ЧͷӾЧUSING Ӿֻ PREPAREd ̬ЧDEALLOCATE вʹ FOR Ӿ䲻 LOB WRITE APPEND ָĿƫ V{1d NLS_NCHAR ѡָ UCS2 ܽ UCS2 ͵ȼۻαδڿɹģʽƫֵ ABSOLUTE ģʽ²ΪCommon SQL Front End ʹѡ OUTLINE, ʹѡ SQLCHECK=SEMANTICS(FULL)ʹѡ OUTLINPREFIX, ʹѡ OUTLINEʹѡ RUNOUTLINE, ʹѡ OUTLINE޷򿪴 SQL ļ޷򿪴־ļƵijȳƴٵĿ޷