group__g__demo.html

ORACLE编程的好东西,纯C写的OCI封装.很好用,支持数据池.

        test_immediate();
        test_immediate_format();
        test_fetch();
        test_bind1();
        test_bind2();
        test_piecewise_insert();
        test_piecewise_fetch();
        test_lob();
        test_nested_table();
        test_ref_cursor();
        test_plsql();
        test_dates();
        test_timestamp();
        test_describe();
        test_returning();
        test_returning_array();
        test_object_insert();
        test_object_fetch();
        test_scrollable_cursor();
        test_collection();

        drop_tables();

        disconnect();
    }
    <span class="keywordflow">else</span>
    {
        print_mstr(<a class="code" href="group__g__error.html#ga06418c61c432aaaa725fecdd28bcb96" title="Retrieve error message from error handle.">OCI_ErrorGetString</a>(<a class="code" href="group__g__error.html#gf2abe52ad5b278f65dd97a44a2adac4c" title="Retrieve the last error occured within the last OCILIB call.">OCI_GetLastError</a>()));
    }
  
    cleanup();

    print_text(<span class="stringliteral">"\npress any key to exit..."</span>);
 
    getchar();

    <span class="keywordflow">return</span> EXIT_SUCCESS;
}

<span class="comment">/* ------------------------------------------------------------------------ *</span>
<span class="comment"> * cleanup</span>
<span class="comment"> * ------------------------------------------------------------------------ */</span>

<span class="keywordtype">void</span> cleanup(<span class="keywordtype">void</span>)
{
    <a class="code" href="group__g__init.html#g639706aa8e9689c7ebffc018fac6d3ae" title="Clean up all resources allocated by the library.">OCI_Cleanup</a>();

    print_frmt(<span class="stringliteral">"\n%i errors encountered\n\n"</span>, nb_err);
}

<span class="comment">/* ------------------------------------------------------------------------ *</span>
<span class="comment"> * disconnect</span>
<span class="comment"> * ------------------------------------------------------------------------ */</span>

<span class="keywordtype">void</span> disconnect(<span class="keywordtype">void</span>)
{
    <a class="code" href="group__g__connect.html#gc3fe655e96074adb119908be4650a4c9" title="Close a physical connection to an Oracle database server.">OCI_ConnectionFree</a>(cn);
}

<span class="comment">/* ------------------------------------------------------------------------ *</span>
<span class="comment"> * print_version</span>
<span class="comment"> * ------------------------------------------------------------------------ */</span>

<span class="keywordtype">void</span> print_version(<span class="keywordtype">void</span>)
{
    <span class="comment">/* print server string version */</span>
    print_mstr(<a class="code" href="group__g__connect.html#ged47a25a1f96fd630f176fe702ac443a" title="Return the connected database server version.">OCI_GetVersionServer</a>(cn));
    print_text(<span class="stringliteral">"\n\n"</span>);

    print_text(<span class="stringliteral">"\n&gt;&gt;&gt;&gt;&gt; VERSIONS INFORMATION \n\n"</span>);

    print_frmt(<span class="stringliteral">"OCILIB major    version : %i\n"</span>,   OCILIB_MAJOR_VERSION);
    print_frmt(<span class="stringliteral">"OCILIB minor    version : %i\n"</span>,   OCILIB_MINOR_VERSION);
    print_frmt(<span class="stringliteral">"OCILIB revision version : %i\n\n"</span>, OCILIB_REVISION_VERSION);

    <span class="comment">/* print all versions */</span>
    print_frmt(<span class="stringliteral">"OCI compile     version : %i\n"</span>,   <a class="code" href="group__g__init.html#g6fa5693d691752f93dbc6baf07e6cceb" title="Return the major version of OCI used for compilation.">OCI_GetOCICompileVersion</a>());
    print_frmt(<span class="stringliteral">"OCI runtime     version : %i\n\n"</span>, <a class="code" href="group__g__init.html#g771bf5d33dbd0b63d84242819209b35b" title="Return the major version of OCI used for compilation.">OCI_GetOCIRuntimeVersion</a>());

    print_frmt(<span class="stringliteral">"Server major    version : %i\n"</span>,   <a class="code" href="group__g__connect.html#g2d7618d8eae73643dd75067a40e656a1" title="Return the major version number of the connected database server.">OCI_GetServerMajorVersion</a>(cn));
    print_frmt(<span class="stringliteral">"Server minor    version : %i\n"</span>,   <a class="code" href="group__g__connect.html#g8f48a3c755751e5df415160913c6c7ee" title="Return the minor version number of the connected database server.">OCI_GetServerMinorVersion</a>(cn));
    print_frmt(<span class="stringliteral">"Server revision version : %i\n\n"</span>, <a class="code" href="group__g__connect.html#ge4c3b37f1c9fc79d36220aa9c96d4415" title="Return the revision version number of the connected database server.">OCI_GetServerRevisionVersion</a>(cn));

    print_frmt(<span class="stringliteral">"Connection      version : %i\n\n"</span>, <a class="code" href="group__g__connect.html#g6f61147801fce4b69edb4981ba4ea1b7" title="Return the highest Oracle version is supported by the connection.">OCI_GetVersionConnection</a>(cn));
}

<span class="comment">/* ------------------------------------------------------------------------ *</span>
<span class="comment"> * create_tables</span>
<span class="comment"> * ------------------------------------------------------------------------ */</span>

<span class="keywordtype">void</span> create_tables(<span class="keywordtype">void</span>)
{
    print_text(<span class="stringliteral">"\n&gt;&gt;&gt;&gt;&gt; CREATE TABLES FOR DEMO \n\n"</span>);
 
    <span class="comment">/* create types for the demo */</span>
    <a class="code" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b" title="Parse and execute a SQL statement or PL/SQL block.">OCI_ExecuteStmt</a>(st, MT(<span class="stringliteral">"create type t_type as OBJECT (code int, name varchar2(20))"</span>));
 
    <a class="code" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b" title="Parse and execute a SQL statement or PL/SQL block.">OCI_ExecuteStmt</a>(st, MT(<span class="stringliteral">"create type t_test as object "</span>)
                    MT(<span class="stringliteral">"( "</span>)
                    MT(<span class="stringliteral">"    val_int  number, "</span>)
                    MT(<span class="stringliteral">"    val_flt  float, "</span>)
                    MT(<span class="stringliteral">"    val_str  varchar2(30), "</span>)
                    MT(<span class="stringliteral">"    val_date date, "</span>)
                    MT(<span class="stringliteral">"    val_lob  clob, "</span>)
                    MT(<span class="stringliteral">"    val_file bfile, "</span>)
                    MT(<span class="stringliteral">"    val_obj  t_type, "</span>)
                    MT(<span class="stringliteral">"    val_raw  raw(20) "</span>)
                    MT(<span class="stringliteral">")"</span>)); 

    <a class="code" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b" title="Parse and execute a SQL statement or PL/SQL block.">OCI_ExecuteStmt</a>(st, MT(<span class="stringliteral">"create type t_tab1_emp as VARRAY(100) of varchar2(50)"</span>));
    
    <a class="code" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b" title="Parse and execute a SQL statement or PL/SQL block.">OCI_ExecuteStmt</a>(st, MT(<span class="stringliteral">"create type t_tab2_emp as table of varchar2(50)"</span>));

    <span class="comment">/* create table for the demo */</span>
    <a class="code" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b" title="Parse and execute a SQL statement or PL/SQL block.">OCI_ExecuteStmt</a>(st, MT(<span class="stringliteral">"create table test_fetch(code int, article "</span>)
                        MT(<span class="stringliteral">"varchar2(30), price float, creation date)"</span>));

    <a class="code" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b" title="Parse and execute a SQL statement or PL/SQL block.">OCI_ExecuteStmt</a>(st, MT(<span class="stringliteral">"create table test_long_raw(code int, "</span>)
                        MT(<span class="stringliteral">"content long raw)"</span>));
    
    <a class="code" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b" title="Parse and execute a SQL statement or PL/SQL block.">OCI_ExecuteStmt</a>(st, MT(<span class="stringliteral">"create table test_long_str(code int, "</span>)
                        MT(<span class="stringliteral">"content long)"</span>));
    
    <a class="code" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b" title="Parse and execute a SQL statement or PL/SQL block.">OCI_ExecuteStmt</a>(st, MT(<span class="stringliteral">"create table test_lob(code int, content CLOB)"</span>));
 
    <a class="code" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b" title="Parse and execute a SQL statement or PL/SQL block.">OCI_ExecuteStmt</a>(st, MT(<span class="stringliteral">"create table test_object(val T_TEST)"</span>));

    <a class="code" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b" title="Parse and execute a SQL statement or PL/SQL block.">OCI_ExecuteStmt</a>(st, MT(<span class="stringliteral">"create table test_array "</span>)
                        MT(<span class="stringliteral">"( "</span>)
                        MT(<span class="stringliteral">"    val_int number, "</span>)
                        MT(<span class="stringliteral">"    val_flt float, "</span>)
                        MT(<span class="stringliteral">"    val_str varchar2(30), "</span>)
                        MT(<span class="stringliteral">"    val_date date, "</span>)
                        MT(<span class="stringliteral">"    val_lob clob, "</span>)
                        MT(<span class="stringliteral">"    val_file bfile "</span>)
                        MT(<span class="stringliteral">")"</span>)
                    ); 

    <a class="code" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b" title="Parse and execute a SQL statement or PL/SQL block.">OCI_ExecuteStmt</a>(st, MT(<span class="stringliteral">"create table test_coll_varray "</span>)
                        MT(<span class="stringliteral">"( "</span>)
                        MT(<span class="stringliteral">"    departement number, "</span>)
                        MT(<span class="stringliteral">"    employees   t_tab1_emp "</span>)
                        MT(<span class="stringliteral">")"</span>)
                    ); 

    <a class="code" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b" title="Parse and execute a SQL statement or PL/SQL block.">OCI_ExecuteStmt</a>(st, MT(<span class="stringliteral">"create table test_coll_nested "</span>)
                        MT(<span class="stringliteral">"( "</span>)
                        MT(<span class="stringliteral">"    departement number, "</span>)
                        MT(<span class="stringliteral">"    employees   t_tab2_emp "</span>)
                        MT(<span class="stringliteral">") nested table employees store as test_table_emp"</span>)
                    ); 

    <span class="comment">/* insert data into the demo tables */</span>
    <a class="code" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b" title="Parse and execute a SQL statement or PL/SQL block.">OCI_ExecuteStmt</a>(st, MT(<span class="stringliteral">"insert into test_fetch "</span>)
                        MT(<span class="stringliteral">"(code, article, price, creation) "</span>)
                        MT(<span class="stringliteral">"values (1, 'shoes', 3.14, to_date('1978-12-23', 'YYYY-MM-DD'))"</span>));
    
    <a class="code" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b" title="Parse and execute a SQL statement or PL/SQL block.">OCI_ExecuteStmt</a>(st, MT(<span class="stringliteral">"insert into test_fetch "</span>)
                        MT(<span class="stringliteral">"(code, article, price, creation) "</span>)
                        MT(<span class="stringliteral">"values (2, 'shirt', 5.99, to_date('1999-09-12', 'YYYY-MM-DD'))"</span>));
    
    <a class="code" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b" title="Parse and execute a SQL statement or PL/SQL block.">OCI_ExecuteStmt</a>(st, MT(<span class="stringliteral">"insert into test_lob(code,content)  "</span>)
                        MT(<span class="stringliteral">"values (1, EMPTY_CLOB())"</span>));
    
    <a class="code" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b" title="Parse and execute a SQL statement or PL/SQL block.">OCI_ExecuteStmt</a>(st, MT(<span class="stringliteral">"insert into test_long_str(code,content) "</span>)
                        MT(<span class="stringliteral">"values (1, 'Rugby rocks !')"</span>));
   
    <a class="code" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b" title="Parse and execute a SQL statement or PL/SQL block.">OCI_ExecuteStmt</a>(st, MT(<span class="stringliteral">"insert into test_coll_varray(departement,employees) "</span>)
                        MT(<span class="stringliteral">"values (1, t_tab1_emp('Peter', 'John', 'Paula', 'Gina'))"</span>));