Re: [PHP-DEV] Ora_Bind() From: Thies C. Arntzen (thies <email protected>)
Date: 08/13/99

in the old "ora_*" module you need to define the variable BEFORE you can
bind it...

do:

$input = 129;
ora_bind($curs, "input", ":in", 5, 1);

and everything should work - but beware that the ora_ bind variables*have*
to be in the global php scope!

the oci* functions are far more flexible - consider using them (if you
have oracle >= 8).

regards,
tc

On Fri, 13 Aug 1999, Andy wrote:

> Hi guys!
>
> Well, why this simple example from PHP3 manual doesn't work?
>
> <?php
> ora_parse($curs, "declare tmp INTEGER; begin tmp := :in; :out := tmp; :x :=
> 7.77; end;");
> ora_bind($curs, "result", ":x", $len, 2);
> ora_bind($curs, "input", ":in", 5, 1);
> ora_bind($curs, "output", ":out", 5, 2);
> $input = 765;ora_exec($curs);
> echo "Result: $result<BR>Out: $output<BR>In: $input";
> ?>
> script returned
> Warning: Can't find variable for parameter in <script_name>
>
> Using Solaris 2.6, Oracle 7.3.3, PHP 3.0.11
>
> Please help and explain what is wrong.
>
> Regards,
> Andy
>
>
>
> --
> PHP Development Mailing List <http://www.php.net/>
> To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
> For additional commands, e-mail: php-dev-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
>
>

Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!"
Digital Collections Phone +49 40 235350 Fax +49 40 23535180
Hammerbrookstr. 93 20097 Hamburg / Germany 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>