when i create a view through query with parameter it is giving error but that query is running in database
and i think error :- "unknown column 'C001' in where clause" is Invalid .
query :- (select * from department where deptno=@input)
please tell me what is the problem
Finished with error: Error executing query. Total time 0.123 seconds.
QUERY [VIRTUAL] [ERROR]
QUERY [JDBC WRAPPER] [ERROR]
QUERY [JDBC ROUTE] [ERROR] Received exception with message 'Unknown column 'C001' in 'where clause''