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
partial SQL query as a parameter
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 17
- Joined: Tue Jan 25, 2011 5:24 am
- Location: Bangalore
-
- Participant
- Posts: 17
- Joined: Tue Jan 25, 2011 5:24 am
- Location: Bangalore