odbc- result set not displayed

i connect to oracle 8.1.6 (8i release 2) using php odbc functions. insert, delete, update works perfectely. but when it comes to select statament, the querry is executed ; but displaying of the result set gives error. The error is : Oracle connectivity test - SELECT stmt Warning: Supplied argument is not a valid ODBC result resource in c:\inetpub\wwwroot\myPHP\odbcAccesstest.php on line 16 Warning: Supplied argument is not a valid ODBC result resource in c:\inetpub\wwwroot\myPHP\odbcAccesstest.php on line 17" The code is as follows: <html> <head> Oracle connectivity test - SELECT stmt <title>ORA test </title> </head> <body> <? $connection = odbc_connect("users","deepaks","deepaks@d"); $sql = "SELECT * FROM USERS"; $sql_stmt = odbc_prepare($connection, $sql); $sql_result = odbc_execute($sql_stmt); odbc_result_all($sql_result, "border=1"); odbc_free_result($sql_result); odbc_close($connection); ?> </body> </html> can any one tell me the reason and a solution for the problem. thanx deepaks ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com