DSXchange

Hi All,

I used OracleStage as an lookup.and i wrote an user-defined sql as:

select day_id,store_id, count(*) Record_count from dm_sale group by day_id,store_id.

I can able to ran the sql using Toad or sqlplus.

But while running the job it throws an error oraillegal variable/number

day_id decimal(key field)
store_id decimal(key field)
Record_count decimal

Please help me on how to resolve trhis issue.

Satheesh

Please post the exact SQL as displayed in your Oracle stage. Is this generated SQL or user-defined SQL?

Ray, they did.

Satheesh, your problem has been asked and answered quite a number of times here already, so many times that I just don't feel the need to spell it all out again. Search for some unique part of your error message to see what I mean. For example, I did an Exact search for ORA-01036 (dash not colon) and found several conversations detailing both your problem and the solution.