AW: [PHP-DB] Oracle Function Calls

YOu have to form proper SQL-Statements try to parse and execute: select foo_function ('paramstr', 999) from dual; dual is a dummy table; then fetch the resultrow and ociresult($stmt, 1) will return your functionreturnvalue mk -----Ursprungliche Nachricht----- Von: Richard S. Crawford [mailto:rscrawford@mossroot.com] Gesendet: Mittwoch, 7. Marz 2001 22:11 An: php-db@lists.php.net Betreff: [PHP-DB] Oracle Function Calls Ah! My bad! I sent this question out with the wrong subject line. My apologies to everyone that I confused. At 01:07 PM 3/7/01 -0800, Richard S. Crawford wrote: >I desperately need to know whether it is possible to call an Oracle >function in PHP. For example... > >$functionResult=hubins($name,$commit_yn) > >where hubins is a stored procedure in our Oracle database. > >Can this be done? My first thought was to do something like this: > >$functionCall="hubins($name,$commit_yen)"; > >then then do > >ociexecute($functionCall); > >...but that, of course didn't work. > >Any thoughts? > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- http://www.mossroot.com/index.php AIM Handle: Buffalo2K e-mail: rscrawford@mossroot.com "When you lose the power to laugh at yourself, you lose the power to think straight." --Clarence Darrow -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net