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
ORA:01036
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers