This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We encountered an issue with clob data. Looks like alteryx is very slow performing while loading clob data to Oracle database. We need to figure a better way to handle the clob data.
Any one encountered this issue, while loading clob data.
ORA-24801: illegal parameter value in OCI lob function
while loading csv file to clob datatype type table, we are encountering this issue. We tried loading manually using toad it worked but through alteryx it fails always. Any sugesstions.
To further Sugus discussion around CLOBs it would be nice to see Alteryx fix up a bug in the Oracle database connection's handling on CLOBS. Currently, CLOB fields are randomly truncated when read in using the OCI Oracle reader. This can be fixed using an ODBC connection, however, the workaround adds complexity for users. I would like to see CLOBs handled natively in the Oracle connection.
Running v 10.6, I'm encountering this: illegal parameter value in OCI lob function... Each time an error is thrown, I'm seeing at least one 'EMPTY_CLOB' reference in the error output.
This occurs when there are weird 'blanks' in the column values. Try using dummy delimiter(to check for the unidentifiable value in CLOB column) and this will fix the issue. This worked for us.
Also, our workflow which was running for 4 hours completed in 30 min after adding this delimiter function.
Another workaround to this that we have found is to use an odbc connection instead of the oci connection and it fixed the problem too.
@smbourke Can you please help with some screenshots? I am trying to load data into Oracle DB using OCI connection but facing the same error as @Sugu
Error: Output Data (142): DataWrap2OCI:: SendBatch: ORA-24801: illegal parameter value in OCI lob function
Appreciate it. TIA!
I was able to figure out the solution for this. This error comes up when we are trying to load empty cells of data into Oracle table. Instead, we can use a Multi-Field formula tool and have this formula to replace null with 0.
Once replaced, it should be good to go and load into table without any issues.
Hi neither the multi field tool or the data cleansing tool have resolved the issue and I believe the error I am getting is because I am attempting to insert (ORA-24801) empty clobs into an oracle database via an OCI connection. Has anyone found a method to identify and populate an empty clob read in from an oracle datasource?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.