ORACLE FUNCTION
| From: | MaNu | Date: | Fri, 31 Oct 2003 12:06:37 +0000 |
| Subject: | ORACLE FUNCTION | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31373@lists.php.net to get a copy of this message | ||
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 = ocifetchstatement($parsed, $result);
echo $numRows; --> 1
echo $result["PIPPO"][0]; --> NULL
the function using SqlNavigator with the same SqlStatment return a valid NUMBER
WHY?!?!?!
@##@@!
MaNu