Re: Ora_Bind()

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@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > 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