PutEnv("ORACLE_SID=ORASID");
$connection1 = Ora_Logon ("usuario@s...", "senha");
if ($connection1 == false)
{
echo Ora_ErrorCode($connection1).": ".Ora_Error($connection1)."
";
exit;
}
$cursor1 = Ora_Open ($connection1);
if ($cursor1 == false)
{
echo Ora_ErrorCode($connection1).": ".Ora_Error($connection1)."
";
exit;
}
$query1 = "select
valor
from
tr";
$result1 = Ora_Parse ($cursor1, $query1);
if ($result1 == false)
{
echo Ora_ErrorCode($cursor1).": ".Ora_Error($cursor1)."
";
exit;
}
$result1 = Ora_Exec ($cursor1);
if ($result1 == false)
{
echo Ora_ErrorCode($cursor1).": ".Ora_Error($cursor1)."
";
exit;
}
$i=0;
while (Ora_Fetch_Into ($cursor1, &$values))
{
$i++;
$upf[$i] = $values[$i];
}