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:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 7. Marz 2001 22:11
An: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>

--
http://www.mossroot.com/index.php
AIM Handle: Buffalo2K
e-mail: [EMAIL PROTECTED]
"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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to