| inconsistent datatypes [message #266718] |
Tue, 11 September 2007 08:42  |
raj_chmi
Messages: 7
Registered: August 2007
Location: HYDERABAD
|
Junior Member |
|
|
Hi All,
I am just trying to execute this query but it give the following error
please if any one is here to solve this problem ,, i ll be thankfull for him.
create table t1(
flex_value_set_name varchar2(60),
additional_where_clause varchar2(4000));
insert into t1
select
f1.flex_value_set_name,
replace(f2.additional_where_clause,chr(10),' ')
from
fnd_flex_value_sets f1,
fnd_flex_validation_tables f2
where
f1.FLEX_VALUE_SET_ID = f2.FLEX_VALUE_SET_ID
and F1.VALIDATION_TYPE = 'F'
AND F1.FLEX_VALUE_SET_NAME = 'AVZ%';
The error in SQL Plus is:
ERROR at line 4:
ORA-00932: inconsistent datatypes: expected NUMBER got LONG
|
|
|
|
| Re: inconsistent datatypes [message #266721 is a reply to message #266718] |
Tue, 11 September 2007 08:49  |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Please always post your Oracle version (4 decimals).
Describe ALL tables.
Regards
Michel
[Updated on: Tue, 11 September 2007 08:50] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
