My job is very simple srcoraoci--->trm---->trgoraoci
when i clicked view data its displaying without errors.
The problem is when i run the job i am getting only one log entry it says
error type is fatal
deps.sourceDependent: ORA-00911: invalid character and job aborted.
I am wondering whats the cause for the above error.
Invalid Character
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA
Why don't you re-type your user defined SQL.
It works sometime.
FYI
Error: ORA-00911: invalid character
Cause: You tried to tried to execute an SQL statement that included a special character.
Action: The options to resolve this Oracle error are:
This error occurs when you try to use a special character in an SQL statement. If a special character other than $, _, and # is used in the name of a column or table, the name must be enclosed in double quotations.
This error may occur if you've pasted your SQL into your editor from another program. Sometimes there are non-printable characters that may be present. In this case, you should try retyping your SQL statement and then re-execute it.
This error occurs when a special character is used in a WHERE clause and the value is not enclosed in single quotations.
For example, if you had the following SQL statement:
SELECT * FROM suppliers
WHERE supplier_name = ?;
You would receive the following error message ORA-00911
You could correct this error by enclosing the ? in single quotations as follows:.
SELECT * FROM suppliers
WHERE supplier_name = '?';
It works sometime.
FYI
Error: ORA-00911: invalid character
Cause: You tried to tried to execute an SQL statement that included a special character.
Action: The options to resolve this Oracle error are:
This error occurs when you try to use a special character in an SQL statement. If a special character other than $, _, and # is used in the name of a column or table, the name must be enclosed in double quotations.
This error may occur if you've pasted your SQL into your editor from another program. Sometimes there are non-printable characters that may be present. In this case, you should try retyping your SQL statement and then re-execute it.
This error occurs when a special character is used in a WHERE clause and the value is not enclosed in single quotations.
For example, if you had the following SQL statement:
SELECT * FROM suppliers
WHERE supplier_name = ?;
You would receive the following error message ORA-00911
You could correct this error by enclosing the ? in single quotations as follows:.
SELECT * FROM suppliers
WHERE supplier_name = '?';
Regards
VS
VS
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA