OraFAQ Forum: SQL & PL/SQL » Getting error 'ORA-01756: quoted string not properly terminated'

Home » SQL & PL/SQL » SQL & PL/SQL » Getting error 'ORA-01756: quoted string not properly terminated'

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Getting error 'ORA-01756: quoted string not properly terminated' [message #187448]

Mon, 14 August 2006 01:23

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

Report message to a moderator

Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187505 is a reply to message #187448]

Mon, 14 August 2006 04:38

Frank
Messages: 7901
Registered: March 2000

Senior Member

whatever you do, make sure you don't provide any examples! We LOVE guessing!

Report message to a moderator

Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187541 is a reply to message #187448]

Mon, 14 August 2006 07:02

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.

Report message to a moderator

Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187542 is a reply to message #187448]

Mon, 14 August 2006 07:06

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

Report message to a moderator

Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187545 is a reply to message #187542]

Mon, 14 August 2006 07:12

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187548 is a reply to message #187545]

Mon, 14 August 2006 07:22

orafaqer
Messages: 48
Registered: July 2006

Member

Littlefoot wrote on Mon, 14 August 2006 16:12

http://img127.imageshack.us/img127/1838/1cg9.png

Report message to a moderator

Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187549 is a reply to message #187548]

Mon, 14 August 2006 07:25

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187553 is a reply to message #187549]

Mon, 14 August 2006 07:34

orafaqer
Messages: 48
Registered: July 2006

Member

Have you tried to execute statement using bind variable? Maybe this is an issue...

Report message to a moderator

Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187569 is a reply to message #187448]

Mon, 14 August 2006 08:59

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

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

Report message to a moderator

Re: Getting error 'ORA-01756: quoted string not properly terminated' [message #187679 is a reply to message #187448]

Mon, 14 August 2006 21:02

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.

Report message to a moderator

Previous Topic:	PL/SQL Nested Tables and Memory
Next Topic:	SQL qry doubt ...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 08:05:17 CST 2024