I've tried a few things including using a bind variable for my very large value.
The last suggested fix I haven't tried is breaking down the large value into a varchar2s and passing it into DBMS_SQL. The basic problem is the following: This code returns the error "ORA-01704: string literal too long".
I was looking a technique outside of Metasploit’s db_nmap command, which stores NMAP results in a database for later analysis, that enables me to generate some kind of reporting on scanned hosts.
An Oracle Lob differs from an Oracle BFile in that the data is stored on the server instead of in a physical file in the operating system.
The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning.
I want to create an insert script which will be used only to insert one record into one table. Whenever I try, it says can not insert string is so long . see below for an example of inserting a large string via an anonymous block which I believe will do everything you need it to do.Your dynamic SQL is trying to concatenate the CLOB as part of the SQL statement, turning it into a string literal.If dynamic SQL were required, you'd need to use bind variables.Fewer characters would be preferable, and this would only work if the differences do occur in the first 4000 characters.SELECT DISTINCT CAST (SUBSTR(description, 0, 4000) AS VARCHAR2(4000)) AS description, threat_id FROM foo Also, be careful with the "distinct" operator in Oracle queries.