MaNu wrote:
Function :
FUNCTION PREZZO_TOT (
pUtente in v_utenti.utente%type,
pTrasp in char
) return NUMBER;
Php
$query = "SELECT poe.carrello.prezzo_tot('AATCXNK2EN3RDKB','1') PIPPO FROM dual";
$parsed = ociparse($conn,$query);
ociexecute($pars
Function :
FUNCTION PREZZO_TOT (
pUtente in v_utenti.utente%type,
pTrasp in char
) return NUMBER;
Php
$query = "SELECT poe.carrello.prezzo_tot('AATCXNK2EN3RDKB','1') PIPPO FROM dual";
$parsed = ociparse($conn,$query);
ociexecute($parsed);
$numRows = ocifetchst
Problem solved!
Thanks to everyone who helped out (and to our system DBA for reminding me
that an Oracle function is just a type of stored procedure).
For what it's worth, here is the code that I wound up using (sensitive
company information 'ed out, of course):
The value of $result
this chunk of code comes out of
http://www.php.net/manual/en/function.ocinewcursor.php
Hope that helps, I havn't gone there (yet).
""Richard S. Crawford"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Ah! My bad! I sent this question out with the wrong s
Hm. Assuming that I don't have the option of rewriting the function to a
procedure, is there another way to go?
At 10:54 PM 3/7/01 +0100, Matthias Kopolt wrote:
>Oracle Divides Function in several Groups
>
>DML means Data-Manipulating function;
>
>(in your funciton is a update or insert)
>
>to
dure needs to declare the second argument as in and can declare the
second one as "out" or "in out"
mk
-Ursprungliche Nachricht-
Von: Richard S. Crawford [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 7. Marz 2001 22:46
An: [EMAIL PROTECTED]
Betreff: Re: AW: [PHP-DB] Orac
str', 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
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. Craw
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
