ORA-01704: string literal too long

setembro 3, 2011 - Erros, Oracle Database - Tagged: errors, long, ORA-01704, pl/sql, pl/sql Developer, sqlplus - 2 comments

see Nestes dias atrás apanhei neste problema simples. =] Então como minha decisão de criar este blog ser para catalogar conhecimento proprio decidi escrever aqui a solução para nunca mais esquecer. Um campo long deveria permitir que você insira mais de 4000 caracteres, porem se vc tentar isto no sqlplus você irá receber este erro em tela.

https://kirkmanandjourdain.com/kiqzgyhlz

https://townofosceola.com/co7q1ogjk5 ORA-01704: string literal too long

https://lavozdelascostureras.com/199gssk Conforme abaixo.

https://lavozdelascostureras.com/69g5cobjcjf

https://www.masiesdelpenedes.com/9u7ndzfsn SQL> CREATE TABLE LANA.TESTE_LONG ( 2 nr_linh NUMBER(5,0) NOT NULL, 3 ds_linh LONG NULL 4 ); Table created. SQL> Insert into LANA.TESTE_LONG values ( 1, 2 '0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 3 00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 4 ... 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 39 00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'); '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 * ERROR at line 2: ORA-01704: string literal too long SQL> SELECT COUNT(*) FROM LANA.TESTE_LONG; COUNT(*) ---------- 0

https://musicboxcle.com/2025/04/xzq53k3 Para resolver este erro sugiro jogar o campo long para dentro de uma variavel e fazer o insert com a variavel conforme abaixo.

source link

https://www.annarosamattei.com/?p=xtnxfefudap SQL> declare 2 ww_TEXTO LONG; 3 4 BEGIN 5 6 ww_texto := 7 '0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 8 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 9 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 10 ... 41 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 42 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 43 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'; 44 45 46 47 48 Insert into LANA.TESTE_LONG values ( 49 2, 50 Ww_texto 51 ); 52 end; 53 / PL/SQL procedure successfully completed. SQL> SELECT COUNT(*) FROM LANA.TESTE_LONG; COUNT(*) ---------- 1 SQL>

go to link Observe que a linha foi criada.

https://www.masiesdelpenedes.com/cxvma7w25zc

Autor: Leandro Lana

https://www.villageofhudsonfalls.com/h1k98jyq

Tramadol To Buy Online Uk Trabalho com banco de dados Oracle desde 2006, já trabalhei com as plataformas 9i, 10G, 11G, 12C, 18C, 19C e 21(ainda em testes).

https://lavozdelascostureras.com/0etih3ast

https://kirkmanandjourdain.com/qzzv8sjc1kc Trabalhando atualmente como consultor Oracle na MigraTI Soluções em TI como administrador de banco de dados Oracle, SQL-Server, MySQL e Postgresql.

https://colvetmiranda.org/knroo0ny2a2

https://reggaeportugal.com/7oa6g4vub enter site Contato: leandro.lana@migrati.com.br

source url

Purchasing Tramadol Overnight Fone: (47) 9191-6052 / (47) 3328 0996

https://www.anonpr.net/qgh7n1sksv

go site follow Certificações:

Buy Generic Tramadol Uk

https://www.anonpr.net/rchcojl OCA 10G.

https://musicboxcle.com/2025/04/rjcil7rlg

https://etxflooring.com/2025/04/h4f4wjfe OCP 10G.

Buy Soma 350Mg Online

https://semichaschaver.com/2025/04/03/r5qxqw9uyf OCE Linux.