Re: AW: [PHP-DB] Oracle Function Calls

Here is the error that I get when I try this approach: ORA-14551: cannot perform a DML operation inside a query At 10:26 PM 3/7/01 +0100, Matthias Kopolt wrote:

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 -- 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