Questions tagged [ora-01704]
5 questions
1
vote
1 answer
ORA-01704 String literal too long when using with Code Igniter
Currently I am develop web app using Code Igniter and Oracle database. When I try to insert long char for CLOB column I get error
ORA-01704 String literal too long
How to fix this in CI?
Say I have a table in oracle like this
CREATE TABLE test(
…
Lhuqita Fazry
- 291
- 4
- 12
1
vote
2 answers
ORA-01704 error, insert string longer than 4000 chars
I am using PHP to insert data to Oracle db. There is a table field with datatype CLOB but it allows to insert upto 4000 characters. I did a bit of searching on Google and found that PL/SQL can insert more than 4000 chars to CLOB field. Then I plan…
Simon
- 819
- 1
- 10
- 18
0
votes
1 answer
Is there any way using generic sql to insert a string longer than 4000 chars into a CLOB
Is there any way using generic sql to insert a string longer than 4000 chars into a CLOB
New Column Added:
ALTER TABLE MESSAGES ADD (MESSAGE_CLOB CLOB);
INSERT INTO TF_STP_MESSAGES
(ID,
MESSAGE_CLOB)
VALUES…
Rami Nassar
- 303
- 1
- 4
- 13
0
votes
1 answer
dbms_xmlgen.getxml statement throwing ORA-01704: string literal too long
So I have this SQL statement that I am calling within the dbms_xmlgen.getxml function and I am receiving the error ORA-01704: string literal too long.
I believe the issues is that the SQL statement I am calling within the function is just too big. …
Batad
- 15
- 5
0
votes
2 answers
How can I avoid that this java.sql.SQLException: ORA-01704: string literal too long is thrown?
I am working on an old legacy Java application and I have some problem with this method that perform a simple insert query on an Oracle database:
private boolean insertFlussoXmlsdi(DBOperatore op, String numeroFattura, String dataFattura, String…
AndreaNobili
- 40,955
- 107
- 324
- 596