Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01704 IN ORACLE (oracle 10g,sql developer)
ORA-01704 IN ORACLE [message #580494] Mon, 25 March 2013 07:59 Go to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Hi,
While we do insert record,it is displaying "string literal too long".
We use NVARCHAR(2000) datatype for that column.Kindly do needful.

Regards
Siraj.j
Re: ORA-01704 IN ORACLE [message #580495 is a reply to message #580494] Mon, 25 March 2013 08:01 Go to previous messageGo to next message
Michel Cadot
Messages: 59407
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because the constant string is too long, not the column (for the moment).

Regards
Michel
Re: ORA-01704 IN ORACLE [message #580496 is a reply to message #580495] Mon, 25 March 2013 08:03 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Hi,
But i want to insert yhe whole string in that column.Which datatype i need to use.Shall i use long varchar.
Re: ORA-01704 IN ORACLE [message #580497 is a reply to message #580496] Mon, 25 March 2013 08:20 Go to previous messageGo to next message
cookiemonster
Messages: 11069
Registered: September 2008
Location: Rainy Manchester
Senior Member
Again - datatype is not the problem. The string literal - the text in quotes in your code that you are trying to use - is too long.
Split it into chunks and concatenate it back together for the insert.
Re: ORA-01704 IN ORACLE [message #580500 is a reply to message #580497] Mon, 25 March 2013 08:37 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Hi,
how to Split long data into chunks and concatenate it?
Re: ORA-01704 IN ORACLE [message #580503 is a reply to message #580500] Mon, 25 March 2013 08:59 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: ORA-01704 IN ORACLE [message #580506 is a reply to message #580500] Mon, 25 March 2013 09:14 Go to previous messageGo to next message
Michel Cadot
Messages: 59407
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
siraj.accet@gmail.com wrote on Mon, 25 March 2013 14:37
Hi,
how to Split long data into chunks and concatenate it?


Instead of 'abcdef' write 'abc'||'def'.

Regards
Michel

Re: ORA-01704 IN ORACLE [message #580508 is a reply to message #580506] Mon, 25 March 2013 09:24 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Thank u..I will try...
Re: ORA-01704 IN ORACLE [message #580509 is a reply to message #580508] Mon, 25 March 2013 09:29 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: ORA-01704 IN ORACLE [message #580513 is a reply to message #580506] Mon, 25 March 2013 10:33 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Hi,
I used SUBSTR function to caoncat that var length string which is having more than 4000 bytes.But how can i get that maximum length of that string.Because input string is given dynamically.So i need to provide dynamic query based on string length.

EX:

INSERT INTO DATASIZE_TEMP(ID,TXT)
VALUES(1,SUBSTR(LPAD('あ',20,'金'),1,5)||SUBSTR(LPAD('あ',20,'金'),6,5));

Here i know the input string length that is 10.
Japanese character will hold 2 byte for a single char.

But in application how can i find the dynamic length.Length function always giving maximum of 4000 bytes.So without length function how can i find dynamic input string length..

Kindly do needful.
Re: ORA-01704 IN ORACLE [message #580515 is a reply to message #580513] Mon, 25 March 2013 10:40 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
PLEASE read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/


>.But how can i get that maximum length of that string.Because input string is given dynamically.
do NOT tell us.
SHOW us.
We only know what you post here.
From exactly where & how does this mythical dynamic string get delivered to your code? What datatype is this dynamic string?

Re: ORA-01704 IN ORACLE [message #580579 is a reply to message #580515] Tue, 26 March 2013 01:02 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Hi,
Input string is given by application.If i need to use substring,i should know the max length of that.
Re: ORA-01704 IN ORACLE [message #580581 is a reply to message #580494] Tue, 26 March 2013 01:03 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
We are using NVARCHAR2(2000).
Re: ORA-01704 IN ORACLE [message #580584 is a reply to message #580579] Tue, 26 March 2013 01:17 Go to previous messageGo to next message
Michel Cadot
Messages: 59407
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
siraj.accet@gmail.com wrote on Tue, 26 March 2013 07:02
Hi,
Input string is given by application.If i need to use substring,i should know the max length of that.


What is "that"?
1/ If the string is given by the application then it is in a variable and then you can't have this error unless you don't use bind variables and concatenate the given string inside the query.
2/ If you use AAL16UTF16 character set then the maximum length of a string in your field is 1000 characters.

Regards
Michel

Re: ORA-01704 IN ORACLE [message #580589 is a reply to message #580581] Tue, 26 March 2013 01:33 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
CREATE TABLE DATASIZE_TEMP
(
ID NUMBER,
TXT NVARCHAR2(2000)
);

INSERT INTO DATASIZE_TEMP
VALUES (1,'金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金');

SELECT LENGTH(TXT),txt FROM DATASIZE_TEMP;


RESULT:

Table created.

SP2-0027: Input is too long (> 2499 characters) - line ignored
0 rows created.


Here the input is a dynamic string which is given by application.So what i have to do to insert this type of string without any issues...
Re: ORA-01704 IN ORACLE [message #580590 is a reply to message #580589] Tue, 26 March 2013 01:35 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
select length('金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金 ')from dual;

RESULT:
SP2-0027: Input is too long (> 2499 characters) - line ignored




Re: ORA-01704 IN ORACLE [message #580591 is a reply to message #580584] Tue, 26 March 2013 01:37 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
We use hibernate.So we are using direct sql query.
Re: ORA-01704 IN ORACLE [message #580592 is a reply to message #580591] Tue, 26 March 2013 01:39 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Without knowing the length how we can do concat.
Re: ORA-01704 IN ORACLE [message #580593 is a reply to message #580591] Tue, 26 March 2013 01:41 Go to previous messageGo to next message
Michel Cadot
Messages: 59407
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I can't say more than what I said: "use bind variables":

INSERT INTO DATASIZE_TEMP VALUES (1,:var);
select length(:var) from dual;
Post the result of "describe DATASIZE_TEMP".

Regards
Michel
Re: ORA-01704 IN ORACLE [message #580596 is a reply to message #580593] Tue, 26 March 2013 01:53 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
select length(:金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 � �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金)from dual;

RESULT:
SP2-0027: Input is too long (> 2499 characters) - line ignored

INSERT INTO DATASIZE_TEMP VALUES (1,:金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金);

RESULT:
SP2-0027: Input is too long (> 2499 characters) - line ignored


Re: ORA-01704 IN ORACLE [message #580597 is a reply to message #580596] Tue, 26 March 2013 01:55 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
CREATE TABLE DATASIZE_TEMP
(
ID NUMBER,
TXT NVARCHAR2(2000)
);
Re: ORA-01704 IN ORACLE [message #580599 is a reply to message #580597] Tue, 26 March 2013 02:01 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
VARIABLE BIND_VAR NVARCHAR2(2000):='金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 金金�� �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ��金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� 金';
BEGIN
SELECT LENGTH(:BIND_VAR) FROM DUAL;
END;


RESULT:

SP2-0027: Input is too long (> 2499 characters) - line ignored
SP2-0552: Bind variable "BIND_VAR" not declared.
Re: ORA-01704 IN ORACLE [message #580602 is a reply to message #580599] Tue, 26 March 2013 02:10 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
VARIABLE BIND_VAR NVARCHAR2;
DECLARE var_len number;
BEGIN
:BIND_VAR:='金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金� ��金金�� �� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� ��金金金 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� 金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� ��金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� ���� �金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金金 �� �� 金';
SELECT LENGTH(:BIND_VAR)into var_len FROM DUAL;
END;


RESULT:

SP2-0027: Input is too long (> 2499 characters) - line ignored
PL/SQL procedure successfully completed.
Re: ORA-01704 IN ORACLE [message #580606 is a reply to message #580602] Tue, 26 March 2013 02:26 Go to previous message
Michel Cadot
Messages: 59407
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ You did not post what I asked
2/ Do you understand that you CANNOT have a string literal (a constant) larger than the maximum in SQL and PL/SQL, ANYW>AY you try it?

Regards
Michel
Previous Topic: BULK COLLECT and return a RECORD as OUT param
Next Topic: multiple rows based on one column
Goto Forum:
  


Current Time: Tue Oct 21 06:21:40 CDT 2014

Total time taken to generate the page: 0.09787 seconds