Union Query for CLOB datatype Objects

building reports webintelligence
1

Hi,

I am using BO XI R3 for my reporting.

In one of the report, the union approach is used. The two objects on which I am doing union are having CLOB data type in the Database and BO has Long text as datatype.

When I run the report, getting error as "The database Error Text ORA 00932 : Inconsistent datatypes: Expect - got CLOB (WIS 10901)

Please advise.

techi_BO (BOB member since 2010-02-13)

2

Hi,

That’s a database limitation when CLOBs are used.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Thanks Marek. Please let me know if is there any workaround for this. I need to use the CLOB datatype in report.

techi_BO (BOB member since 2010-02-13)

4

Then don’t use unioned queries.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

5

Thanks Marek for your quick reply.

As per the requirement, I need to use both Union and CLOB. Just wondering if there is a workaround on this.
Can we do anything on report side to handle this.

techi_BO (BOB member since 2010-02-13)

6

Tricky – perhaps this might work?


select cast(clob as varchar(8000)) as "big_text_1"
union
select cast(clob as varchar(8000)) as "big_text_2"

Also have a look at:

https://forums.oracle.com/forums/thread.jspa?threadID=354987

For an on-report based solution, you could create two details and play with the “match” function perhaps.

Atul Chowdhury (BOB member since 2003-07-07)