ORA-00911 error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
ORA-00911 error
i am trying to insert update data into oracle table and i am getting ora - 00911 error.
my data is clean only---
Input data is--
46|4905|"7701993900100044980253"||||"2009-02-16 04:00:01"||"2009-02-13 16:50:31"
46|4906|"7701993900100044990268"||||"2009-02-16 04:00:01"||"2009-02-13 16:50:31"
Can anybody tell me whats the problem.?
my data is clean only---
Input data is--
46|4905|"7701993900100044980253"||||"2009-02-16 04:00:01"||"2009-02-13 16:50:31"
46|4906|"7701993900100044990268"||||"2009-02-16 04:00:01"||"2009-02-13 16:50:31"
Can anybody tell me whats the problem.?
Looks like Oracle's complaining about invalid characters. Have you checked and validated your data against the Stage column definitions? I'm guessing because you haven't said but your data is read from a sequential file stage delimited by pipe. Have you specified that columns 3, 7 and 9 can be enclosed by double quotes?
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
i have used OCI....
i am reading from a seq. file then transformer then OCI....
though data is getting read properly...it is showing below error in Director...
i am reading from a seq. file then transformer then OCI....
though data is getting read properly...it is showing below error in Director...
Code: Select all
ldiuICVEcoupon..xfm: ORA-00911: invalid character
The value of the row is: COUPON_SET_NBR = 46 COUPON_SEQ_NBR = 4905 ECOUPON_ID = 7701993900100044980253 ACCOUNT_NBR = NULL LOC_NBR = NULL DISTRIBUTION_DTS = NULL PRINT_DTS = 2009-02-16 04:00:01 RECYCLE_DTS = NULL LAST_UPDATE_DTS = 2009-02-13 16:50:31 POST_DTS = 2009-01-01 00:00:00 LAST_UPDATE_USER = ETL
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
Checkout the third column (ECOUPON_ID). It looks as if it start's life as a varchar because your sample data shows double-quotes, and ends up in a number column. If this is the case make sure the quotes are taken care of and there is nothing other then a number being pushed to Oracle. Failing that then capture the offending row and double check the data types against the Oracle table definition. The other thing to check is the column names in the OCI stage match the actual table and that they contain no non-ascii chars.
Last edited by rsaliah on Mon Feb 16, 2009 9:09 am, edited 2 times in total.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
ORA-00911 is due to invalid character..
1.Check if there are any Varchar columns and the characters which are appended by the DS.
2. As you are saying you are trying to update the data, which columns you are tying to update and which columns you are using in where clause ?
3. 'Data is clean only'
What method you had applied to verify the data ?
If there a file..can you check with cat -v in the unix box.
---------------------------------------------------------
1.Check if there are any Varchar columns and the characters which are appended by the DS.
2. As you are saying you are trying to update the data, which columns you are tying to update and which columns you are using in where clause ?
3. 'Data is clean only'
What method you had applied to verify the data ?
If there a file..can you check with cat -v in the unix box.
---------------------------------------------------------
-----------------------------------
Regards
MK
What would you attempt to do if you knew you could not fail?
-----------------------------------
Regards
MK
What would you attempt to do if you knew you could not fail?
-----------------------------------
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai