ORA-00911: invalid character Error
Moderators: chulett, rschirm, roy
ORA-00911: invalid character Error
I have a simple job just a oci stage where i have sysdate dual in which refered to a set of dates.the field am using has a fuction to_char for ex in the source i have to_char(sysdate,'MMDDYY') which again refered to the source databases.hte error am gettng is ORA-00911: invalid character any thoughts
RK
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
chulett wrote:Usually that comes from an unresolved parameter - #XXX# - or you've tacked on a trailing semi-colon. Both the hash and semi are "invalid characters" here. ...
Basically i have the query in the i/p DB stage is
Select to_char(sysdate,'MMDDYY') from dual
On the ref DB i have query from DB in which from the where clause i use the runtime argument from the source which will be to_char(:1,'MMDDYY') so will that changing again gives the problem or do i take to char out in the source DB stage
any thoughts
RK
So, more than just "a simple job just an oci stage", eh? Sorry, but I have no idea what you mean by "On the ref DB i have query from DB in which from the where clause i use the runtime argument from the source which will be to_char(:1,'MMDDYY')".
If it means you are using that bind variable in your source query, you can't, that would need to be a job parameter. If "ref DB" means some kind of lookup, that should work provided your first field is marked as a key.
If it means you are using that bind variable in your source query, you can't, that would need to be a job parameter. If "ref DB" means some kind of lookup, that should work provided your first field is marked as a key.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
chulett wrote:So, more than just "a simple job just an oci stage", eh? Sorry, but I have no idea what you mean by "On the ref DB i have query from DB in which from the where clause i use the runtime argument from the source which will be to_char(:1,'MMDDYY')".
If it means you are using that bind variable in your source query, you can't, that would need to be a job parameter. If "ref DB" means some kind of lookup, that should work provided your first field is marked as a key.
sorry about the late reply actually the bug is not with code but with the data stage versions we are migrating from 7.1 to.8.1 .eventually 8.1 gives o/p of oconv(sysdate,'MMDDYY') as 05/22/10 but 7.1 gives as 05 22 10 so corrected the query worked fine.thanks all for the i/p
Last edited by g_rkrish on Mon May 24, 2010 1:59 am, edited 3 times in total.
RK