concat with variables

[Anon]

$sql_statement = OCIParse($connection, "SELECT * FROM TABLE_NAME WHERE COLUMN_NAME = '$query2.$query3'") or die ("Couldn't parse statement.\n");

Can anyone please tell me why the above code will not work ? ... I am running Oracle8i on Linux.

I have already used the SQL command :
SQL> set concat .

to set the default concat operator.

Please anyone help. Thanks.

[[deleted]]

Rule #1 in working with database: if the query does not do what you want, PRINT IT!

You'll find that you forgot to quote your $query2 and $query3 properly.