partial SQL query as a parameter

[akshu.agni]

hi,

i have a sql query for ex: select col1,col2 where col1='a' and #para1#..

in the above sql the parameter #para1#=END_DT = to_date ('9999-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS').


while execting the job it is throwing "Unrecognized argument: 23:59:59
" fatal error.

can anyone suggest me.

Regards
Akshu

[chulett]

Quotes in parameters are known to be stripped, you need to escape them to protect them. Typically a backslash would work, try that first.

[akshu.agni]

Quotes in parameters are known to be stripped, you need to escape them to protect them. Typically a backslash would work, try that first. ...

Thanks Craig!!