select .... into

[padma]

$CountQuery = "select count(*) into " .$v_count. " from test where id = ".$id;

$CountStatement = @OCIParse($conn, $CountQuery);

@OCIExecute($CountStatement, OCI_DEFAULT);

echo "Count ".$v_count;

Count is not displaying any value.

I am not sure whether it can be done like this way or not.

Thanks

[sarahk]

I'm assuming from the syntax that you're using Oracle.

First things first.

$CountQuery is a string passed down to the database so I suspect that if you echo out $CountQuery you will get:

select count(*) into from test where id = 123;

and that just won't work.

That syntax seems right for the middle of a stored procedure but I think you probably need to review your documentation and compare with some simple examples.

[netizen]

I'm not familiar with Oracle, but try [as] instead of [into]