Hi,

I'm trying to do a select * from an oracle table that has a clob field in it.

SET SQLENGINE=SQLORA
SQL SET SERVER &MYSERV
SQL SELECT * FROM PAL.SD;
TABLE
ON TABLE HOLD AS SD_HOLD
END

However, I receive this error...

(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
(FOC1665) UNSUPPORTED DATA TYPE IN ORACLE INTERFACE
L (FOC1405) SQL PREPARE ERROR.

The master file looks like this for that field...
FIELD=INVENTION_DESCRIPTION ,INVENTION_DESCRIPTION,
TX50 ,TX ,MISSING=OFF,$

I looked at the master file for this table and noticed that the format was different. I tried changing the .mas to make this field a clob but that didn't seem to work. I received the same error. Does anyone know what I need to do to get my select * to work with a clob field?

Thanks...

This message has been edited. Last edited by: Kerry,

Hi webfocusdev,

Has this issue regarding error with clob field been resolved?

I ran a quick search on Information Builder's online documentation and came across the following topics which may be of interest.

Gets -12 recieved using ORACLE CLOB field type
http://techsupport.informationbuilders.com/sps/90631116.html

(FOC1665) UNSUPPORTED DATA TYPE - ORACLE WHEN USING USAGE TX http://techsupport.informationbuilders.com/sps/93411122.html

foc1405 - sql prepare error
http://techsupport.informationbuilders.com/sps/92891089.html

workaround for (FOC1665) error
http://techsupport.informationbuilders.com/sps/10342074.html

You will need to have a userid/password to access these documents.

Hope this helps.

Cheers,

Kerry

Thanks Kerry,

I had to add ora_oci=y to the edaserve.cfg and restart the server.

Hi Kerry,

Do you have any updated links in reply to this?

Hi Doug,

This one has been years so please let me check with our internals regarding the policy on archiving and I will keep you posted.

Cheers,

Kerry

Hi Doug,

I just send you a private message regarding the URLs, can you please check?

Cheers,

Kerry