LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mike.dasilva2@telus.com

I'm trying to link up to an oracle DB and get this error
ERROR opening i/o streams:
Unable to translate OCI type: 112

Installing log (02/18/2010 12:25:53) ...
2010-02-18 12:25:53; Level: 2; Type: 0; Desc: "Unable to translate OCI type: 112"; File: "./../../jigsaw/Code/Source/Oci/OciCodes.cpp"; Line: 66; Context: ""
2010-02-18 12:25:53; Level: 2; Type: 0; Desc: "...exception seen"; File: "./../code/source/brain/DbNodeIo.cpp"; Line: 70; Context: "Salmon::NED::NodeIo::DbInput::DbInput()"
2010-02-18 12:25:53; Level: 2; Type: 0; Desc: "...exception seen"; File: "./../code/source/brain/QueryDumper/QueryDumperNodeControl.cpp"; Line: 125; Context: "Salmon::NED::QueryDumper::QueryDumperNodeControl: :createQueryInput()"
2010-02-18 12:25:53; Level: 2; Type: 0; Desc: "...exception seen"; File: "./../code/source/brain/QueryDumper/QueryDumperNodeControl.cpp"; Line: 99; Context: "Salmon::NED::QueryDumper::QueryDumperNodeControl: :initializeIo()"
Uninstalling log (02/18/2010 12:25:53) ...

I can link up using a JDBC oracle driver but not the OCI Driver

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rabbott

Hi Mike,

Sorry for the delayed response. I searched my e-mail archive and found a similar inquiry from John Elash at TELUS last summer. Are you trying to query a CLOB field? LD does not support that data type via OCI presently.

If you can confirm this, and send us the failed node using the "Help > Report Problem With a Node..." feature in LD (available since 4.1.4), I can see about entering an enhancement request.

Thanks,

- Bob

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Adam Williamson

Hi Bob,

Understand this post is a year old, but is there any signs of clob support via OCI coming to Lavastorm in the near future?

Regards,
Adam Williamson

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rabbott

Hi Adam,

Sorry for the belated response. I circled back to the work done previously on this and found that a report had not been submitted to Engineering. I've just done so and they're already aware of this post and the general requirement for CLOB support for OCI at TELUS.

LAE 4.5.3 is due very soon and it's too late to get this into that release. The next maintenance release is in June, so please check back with us then.

You're probably already aware that the workaround is to use the Oracle JDBC driver.

Thanks and regards,

- Bob

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mlowe

Originally posted by: rabbott
					

LAE 4.5.3 is due very soon and it's too late to get this into that release.  The next maintenance release is in June, so please check back with us then.
			

Is this still an issue?