database - Not All variables Bound Error in SQL prepaired statment in Tibco -

database - Not All variables Bound Error in SQL prepaired statment in Tibco -

i using tibco bw jdbc query activity. blow statment running fine in sql developer not getting compiled gives error "ora-01008: not variables bound"

select (cast(fech2 timestamp) - cast(fech1 timestamp) )total ( select min(case when message ='abc' time_stamp end) fech1, min(case when message ='efg' time_stamp end) fech2 log application = 'mnc' , tid=? grouping tid)

please help? said, there no alter required in sql developer run statement.

sql database oracle oracle-sqldeveloper tibco