ORA:01036

satheesh_color · Post by **satheesh_color** » Mon Dec 17, 2007 5:25 am

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 ora

illegal 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

ray.wurlod · Post by **ray.wurlod** » Mon Dec 17, 2007 5:42 am

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

chulett · Post by **chulett** » Mon Dec 17, 2007 7:30 am

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.