get link 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://pkuatm.org/2024/05/13/st3iskywu9 ORA-01704: string literal too long
https://discovershareinspire.com/2024/05/ecmrxb9d Conforme abaixo.
go site 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
Buy 1000 Valium Online Para resolver este erro sugiro jogar o campo long para dentro de uma variavel e fazer o insert com a variavel conforme abaixo.
https://yplocal.us/hvgt8a56a 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 site Observe que a linha foi criada.
Autor: Leandro Lana
https://emduk.org/040szb7nfo Trabalho com banco de dados Oracle desde 2006, já trabalhei com as plataformas 9i, 10G, 11G, 12C, 18C, 19C e 21(ainda em testes).
go to site Trabalhando atualmente como consultor Oracle na MigraTI Soluções em TI como administrador de banco de dados Oracle, SQL-Server, MySQL e Postgresql.
Buy Hirst Valium click here Contato: leandro.lana@migrati.com.br
https://someawesomeminecraft.com/2024/05/13/1q03vo3 Fone: (47) 9191-6052 / (47) 3328 0996
enter https://annmorrislighting.com/q4iu7i2b Certificações:
go to site OCA 10G.
https://dentaris-sa.com/2024/05/13/jdjjmt6 OCP 10G.
https://www.vertaglia.com/yw69olkrc3 OCE Linux.
https://domainebregeon.com/0ntqxrgz8ih OCE RAC/Cluster.
source site MCP SQL-Server 2008.
https://templedavid.org/symons/4i36rc1q MCITP SQL-Server 2008.
go to link DB2 Fundamentals.
https://www.jacobysaustin.com/2024/05/ocnlfapxf Isso só irá acontecer no sqlplus ou pode ocorrer via programa, tp delphi ou vb para inserir o registro?
Já chegasse a pegar algo assim?
https://aaerj.org.br/2024/05/13/at84uiynoe7 Sim.
isso ocorria no delphi. Já no pl/sql isso não ocorre pois o PL/SQL camufha a solução.
No VB e em algumas outras tecnologias eu não testei.