AnsweredAssumed Answered

Return limit/truncation in SQL Lookup Map function & Error ORA-06512

Question asked by jrmcloughlin on Mar 16, 2017

I have an Oracle database that I'm connecting to in order to call a stored procedure that has a CLOB as an output parameter. As it has output parameters I can only call it in a SQL Lookup function in a map shape.

If the result is sufficiently large I get an exception:

[Function: Sql Lookup]: DB access error!; Caused by: ORA-06502: PL/SQL: numeric or value errorORA-06512: at line 1

I can replicate this behavior in my database client by attempting to write the output using dbms_output.put_line which leads me to think that Boomi may be using this function (or similar) to capture the output. Has anyone had any experience with this?


Additionally, if the result of the call is a smaller value, I'm seeing it truncated to the first 2000 bytes. Is there possibly a maximum length on the character data type? Or are there any other factors that may be causing this?