[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-general
Subject:    [PHP3] Oracle and php2.0.1 binding.
From:       "Dmitri Khrissanov" <hawk () octet ! spb ! ru>
Date:       1999-11-13 8:45:48
[Download RAW message or body]

Hello!

I've tried to bind input variable in parsed SQL statement, and I've met
with some difficulties:
I can easily bind output variable, but binding of input fails, i.e.:

<?
        $rc  = "12345";
        /* This is the SQL query. */
        $query = "declare zzz varchar2(10):='aaaaa'; begin :P1:=zzz; end;";
        Ora_Parse($cursor, $query) ;
        Ora_Bind($cursor, "rc", ":P1", 64);
        $ncols = Ora_Exec($cursor);
?>

This works fine, but:

<?
        $rc  = "12345";
        /* This is the SQL query. */
        $query = "declare zzz varchar2(10):='aaaaa'; begin zzz:=:P1; end;";
        Ora_Parse($cursor, $query) ;
        Ora_Bind($cursor, "rc", ":P1", 64);
        $ncols = Ora_Exec($cursor);
?>

This fails to execute, however binding and parsing works fine.

Oracle 8.0.5 EE Solaris x86 Edition, Apache 1.2.6, PHP/FI 2.0.1


Sincerely yours.

Dmitry Khrissanov





-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe@lists.php.net
To subscribe to the digest, e-mail: php3-digest-subscribe@lists.php.net
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin@lists.php.net

[prev in list] [next in list] [prev in thread] [next in thread]