Home » SQL & PL/SQL » SQL & PL/SQL » Getting error 'ORA-01756: quoted string not properly terminated'
Getting error 'ORA-01756: quoted string not properly terminated' [message #187448] Mon, 14 August 2006 01:23 Go to next message
pulkit_a
Messages: 50
Registered: December 2005
Member
Hi,

I am working with Japneses Character. When i am trying to insert Japnese data into Oracle 9i Tables for some character sets it is unable to recognise the ending quote with the String and through error
"ORA-01756: quoted string not properly terminated" even though the end quotes exists.

If i add 2 spaces OR any thing of 2 character before the ending quotes then it recognize the ending quotes and execute successfully.

I think i need to make some settings..

I really need help..

Regards
Pulkit
Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187505 is a reply to message #187448] Mon, 14 August 2006 04:38 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
whatever you do, make sure you don't provide any examples! We LOVE guessing!
Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187541 is a reply to message #187448] Mon, 14 August 2006 07:02 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
'(,."[ might be some of those which you havent properly completed.the problem is not with japanese character.its with your query.pls post the query for fast answers pls.
Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187542 is a reply to message #187448] Mon, 14 August 2006 07:06 Go to previous messageGo to next message
pulkit_a
Messages: 50
Registered: December 2005
Member
Following is the query...

INSERT INTO AREA(AREA,AREA_NAME,MGR_NAME,CHAIN,CURRENCY_CODE) VALUES(1,'卸売部門','',1,'JPY')


It gives me error for japnese string '卸売部門' but if i put 2 spaces like '卸売部門 ' and try to execute insert it is successfull.

Regards
Pulkit
Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187545 is a reply to message #187542] Mon, 14 August 2006 07:12 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could it be that the last Japanese character (I don't see it; all I can see are 4 squares) acts like some kind of an "escape" character which prevents ' to be used as enclosing character of this string?
icon10.gif  Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187548 is a reply to message #187545] Mon, 14 August 2006 07:22 Go to previous messageGo to next message
orafaqer
Messages: 48
Registered: July 2006
Member
Littlefoot wrote on Mon, 14 August 2006 16:12

Could it be that the last Japanese character (I don't see it; all I can see are 4 squares) acts like some kind of an "escape" character which prevents ' to be used as enclosing character of this string?

http://img127.imageshack.us/img127/1838/1cg9.png
Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187549 is a reply to message #187548] Mon, 14 August 2006 07:25 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you, it looks much prettier than 4 squares, but I still have no idea what this could be.
Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187553 is a reply to message #187549] Mon, 14 August 2006 07:34 Go to previous messageGo to next message
orafaqer
Messages: 48
Registered: July 2006
Member
Have you tried to execute statement using bind variable? Maybe this is an issue...
Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187569 is a reply to message #187448] Mon, 14 August 2006 08:59 Go to previous messageGo to next message
pulkit_a
Messages: 50
Registered: December 2005
Member
Dear Friends,

Thanks a lot for ur comments...I am into a data Migration work and in that the Static data that i am getting from Business people i am populating directly through SQL file having multiple Inserts. Now some data gets inserted and some failes saying "Quoted String not properly terminated"

Can this be Character Set issue... Well i am using

NLS_LANG=JAPANESE.JAPAN.UTF-8

If you feel that the problem can be with character set then suggest what change can i make.

Regards
Pulkit

[Updated on: Mon, 14 August 2006 09:00]

Report message to a moderator

Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187659 is a reply to message #187569] Mon, 14 August 2006 17:09 Go to previous messageGo to next message
wagnerch
Messages: 58
Registered: July 2006
Member
If you are using that NLS_LANG then it is probably not working, it is not formatted right.

Verify by running this query:

SELECT *
  FROM nls_session_parameters
 WHERE parameter IN ('NLS_LANGUAGE', 'NLS_TERRITORY');

PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LANGUAGE
JAPANESE

NLS_TERRITORY
JAPAN


If it doesn't return the above, then it should be:

export NLS_LANG=JAPANESE_JAPAN.UTF8

Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187679 is a reply to message #187448] Mon, 14 August 2006 21:02 Go to previous message
pulkit_a
Messages: 50
Registered: December 2005
Member
Well following is the output from nls_session_parameters table

SELECT *
FROM nls_session_parameters
2 3 WHERE parameter IN ('NLS_LANGUAGE', 'NLS_TERRITORY');

PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LANGUAGE
JAPANESE

NLS_TERRITORY
JAPAN


I think the database settings are OK..

Please suggest.
Previous Topic: PL/SQL Nested Tables and Memory
Next Topic: SQL qry doubt ...
Goto Forum:
  


Current Time: Thu Dec 08 22:14:03 CST 2016

Total time taken to generate the page: 0.08314 seconds