paging in oracle db

[amrigo]

I would like to page the results from an oracle query

I am using the code below and it print the links to the pages but do not display the column values . What can it be?
Thank´s in advance

<?php

$db_conn = ocilogon("xx", "xx", "xx");
if (!$pagina) {
$maior = 10;
$menor = 1;
$pagina = 1;
} else {
$maior = $maior + 10;
$menor = $maior - 9;
}

$conexao = $db_conn;

$sql = "SELECT * FROM TABLE";

$sql = "SELECT * FROM (SELECT rownum AS numero, COLUMN FROM ($sql) ".
"WHERE numero <= $maior ) where rownum >= $menor";

$sql = OCIParse($conexao, $sql);
OCIExecute($sql, OCI_DEFAULT);

$sql2 = "SELECT COUNT(*) as CONTADOR FROM TABLE";
$sql2 = OCIParse($conexao, $sql2);
OCIExecute($sql2, OCI_DEFAULT);

while (OCIFetch($sql2)) {
$conta = OCIResult($sql2, 'CONTADOR');
}

while (OCIFetch($sql)) {
$variavel = OCIResult($sql, 'COLUMN');
echo $variavel;
}

for ($i = 0; $i < $conta; $i++) {
$vai = $pagina +1;
$vaimaior = $vai * 10;

if ($pagina == $i) {
echo $vai;
} else {
echo "<a href='?pagina=$i&maior=$vaimaior'>$vai</a>";
}
}
?>