[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    [PHP-DB] ORACLE FUNCTION
From:       "MaNu" <manuele.macario () libero ! it>
Date:       2003-10-31 12:06:37
[Download RAW message or body]

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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[prev in list] [next in list] [prev in thread] [next in thread]