Return to drcp_functions.inc CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / oci8 / tests

Annotation of embedaddon/php/ext/oci8/tests/drcp_functions.inc, revision 1.1

1.1     ! misho       1: <?php
        !             2: 
        !             3: /* This file contains functions required by the DRCP tests */
        !             4: 
        !             5: function drcp_create_table($conn)
        !             6: {
        !             7:        $create_sql = "CREATE TABLE DRCPTEST (id NUMBER, name VARCHAR2(10), dept VARCHAR2(10))";
        !             8:        $statement = oci_parse($conn, $create_sql);
        !             9:        oci_execute($statement);
        !            10:        
        !            11:        $id_values = array(100,101,102,103,104,105,106,107,108);
        !            12:        $name_values = array("WIILIAMS","JOHN","SMITH","JONES","ADAMS","ROBERT",
        !            13:                                                 "BILL","LAWSON","MARY");
        !            14:        $dept_values = array("ACCOUNTS","HR","HR","ADMIN","ACCOUNTS","HR",
        !            15:                                                 "ACCOUNTS","HR","ACCOUNTS");
        !            16:        for($i=0; $i<8; $i++) {
        !            17:                $insert = "INSERT INTO DRCPTEST VALUES(".$id_values[$i].",'". $name_values[$i]."','".$dept_values[$i]."')";
        !            18:                $s = oci_parse($conn, $insert);
        !            19:                oci_execute($s);
        !            20:        }       
        !            21: }
        !            22: 
        !            23: function drcp_drop_table($conn)
        !            24: {
        !            25:        $ora_sql = "DROP TABLE DRCPTEST";
        !            26:        $statement = oci_parse($conn, $ora_sql);
        !            27:        oci_execute($statement);
        !            28: }
        !            29: 
        !            30: function drcp_update_table($conn)
        !            31: {
        !            32:        $update_stmt ="Update drcptest set dept ='NEWDEPT' where id = 105";
        !            33:        $s1 = oci_parse($conn,$update_stmt);
        !            34:        oci_execute($s1,OCI_DEFAULT);
        !            35:        echo "Update done-- DEPT value has been set to NEWDEPT\n";
        !            36: }
        !            37: 
        !            38: function drcp_select_value($conn)
        !            39: {
        !            40:        $sel_stmt="select dept from drcptest where id=105";
        !            41:        $s2 = oci_parse($conn,$sel_stmt);
        !            42:        oci_execute($s2,OCI_DEFAULT);
        !            43:        while(oci_fetch($s2)) {
        !            44:                echo "The value of DEPT for id 105 is ".oci_result($s2,1)."\n";
        !            45:        }
        !            46: }
        !            47: 
        !            48: function drcp_select_packagevar($conn)
        !            49: {
        !            50:        $sel_stmt="select drcp_test_package.f1 as f1 from dual";
        !            51:        $s2 = oci_parse($conn, $sel_stmt);
        !            52:        oci_define_by_name($s2,'f1',$ret_num);
        !            53:        oci_execute($s2);
        !            54:        while(oci_fetch($s2)) {
        !            55:                echo " The value of the package variable is ".oci_result($s2,1)."\n";
        !            56:        }
        !            57: }
        !            58: 
        !            59: 
        !            60: function drcp_set_packagevar($conn,$num)
        !            61: {
        !            62:        $set_stmt = "begin drcp_test_package.p1($num); end;";
        !            63:        $s1 = oci_parse($conn,$set_stmt);
        !            64:        oci_execute($s1);
        !            65:        echo " Package variable value set to " .$num."\n";
        !            66: }
        !            67: 
        !            68: function drcp_create_package($c)
        !            69: {
        !            70:        $create_package_stmt = "create or replace package drcp_test_package as
        !            71:                        var int :=0;
        !            72:                        procedure p1(var1 int);
        !            73:                        function f1 return number;
        !            74:                        end;";
        !            75:        $s1 = oci_parse($c, $create_package_stmt);
        !            76:        oci_execute($s1);
        !            77:        
        !            78:        $package_body = "create or replace package body drcp_test_package as
        !            79:                procedure p1(var1 int) is
        !            80:                begin
        !            81:                var :=var1;
        !            82:                end;    
        !            83:                function f1 return number is
        !            84:                begin
        !            85:                return drcp_test_package.var;
        !            86:                end;
        !            87:                end;";
        !            88: 
        !            89:        $s2 = oci_parse($c, $package_body);
        !            90:        oci_execute($s2);
        !            91: }
        !            92: 
        !            93: ?>