SQL Language (MOSC)

MOSC Banner

ORA-00932: inconsistent datatypes: expected - got CLOB

edited Dec 23, 2014 10:00AM in SQL Language (MOSC) 4 commentsAnswered

to satisfy union sql. I am using empty_clob function as below. but is showing error.

select * from

(select

    test_type test_type,

    result_type result_type,

    test_column param_name,

    result_column storage_col_name,

    '' value_data_type,

     empty_clob() as enum_data_type

from

    test_result_column_map

where

  mdf_id = 1029

)

union

(           

select

    test_type test_type,

    '' result_type,

    param_name param_name,

    param_column storage_col_name,

    value_data_type value_data_type,

    enum_data_type  enum_data_type

from

    test_param_column_map

where

      mdf_id = 1029

);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center