Variable into Query

[ab_db]

Hi All,

I am trying to pass a variable into the Query   by using the << variable which is throwing a exception 

java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) 

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) ........

DBfit code

DatabaseEnvironment	ORACLE
ConnectUsingFile	.\Connections\ClassDW.config

Given a customer record in the CLASS_DW

Query	SELECT REFERENCE FROM CUSTOMERS WHERE rownum = 1
REFERENCE?
>> custrec = 80129979752

and the customer does not exist in the integration layer

DatabaseEnvironment	ORACLE
ConnectUsingFile	.\Connections\Integration.config

Query	SELECT distinct 0 as CUSTOMER_ID from H_CUSTOMERS where CUSTOMER_ID <> << custrec
CUSTOMER_ID?
0

Any help is appreciated?

Many Thanks,

[ab_db]

Sorry got the answer for the variable in ORACLE use : not << to read the variable. :custrec worked. Cheers