Oracle and PHP Funtion

[padma]

function page_views($p_nav_id)
{
$PageViewsQuery = "select * from dual";

  $PageViewsStatement = @OCIParse($conn, $PageViewsQuery);

@OCIExecute($PageViewsStatement, OCI_DEFAULT);

while(ocifetch($PageViewsStatement))
{

$v_page_views = ociresult($PageViewsStatement, 1);

}

//free the statement
OCIFreeStatement($PageViewsStatement);

return $v_page_views;

}

When I call this function page_views(0), I get the following error.

Warning: ocifreestatement(): supplied argument is not a valid OCI8-Statement resource in .........

What's wrong with my function.

Thanks

[gwchamb]

function page_views($p_nav_id)
{
$PageViewsQuery = "select * from dual";

  $PageViewsStatement = @OCIParse($conn, $PageViewsQuery);

When I call this function page_views(0), I get the following error.

Warning: ocifreestatement(): supplied argument is not a valid OCI8-Statement resource in .........

What's wrong with my function.

Thanks [/B]

Your answer lies in the error message. You haven't supplied a valid DB handle. Presumably, you want to use $conn, but you haven't declared it a global variable (opened elsewhere in your application), nor have you assigned it through ocilogon anywhere in page_views. You don't even pass it as a parameter in the page_views. The moral is to pay attention to the returned error message(s), and think about the information presented to you.

-- Gary