Home » SQL & PL/SQL » SQL & PL/SQL » inconsistent datatypes
inconsistent datatypes [message #266718] Tue, 11 September 2007 08:42 Go to next message
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 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
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

Previous Topic: mail out from Stored Procedure
Next Topic: With after cursor name
Goto Forum:
  


Current Time: Sun Dec 11 02:23:58 CST 2016

Total time taken to generate the page: 0.03842 seconds