Home » SQL & PL/SQL » SQL & PL/SQL » How to execute unicode format SQL script
How to execute unicode format SQL script [message #204797] Wed, 22 November 2006 02:37 Go to next message
Spark_Hong
Messages: 9
Registered: November 2006
Junior Member
Hi,

I have a SQL script saved as unicode format, how can I execute it successfully in Sql plus?

Thanks,
Spark
Re: How to execute unicode format SQL script [message #204798 is a reply to message #204797] Wed, 22 November 2006 02:42 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Now, this might be a stupid question, but - what does it mean "as unicode format"? How does this file look like? If it is an ordinary file which contains (PL/)SQL statements, run it at the SQL*Plus prompt as

SQL> @file_name
Re: How to execute unicode format SQL script [message #204803 is a reply to message #204798] Wed, 22 November 2006 02:51 Go to previous messageGo to next message
Spark_Hong
Messages: 9
Registered: November 2006
Junior Member
Sorry, I don't mean the steps about how to execute, I mean that I write some SQL using Notepad and save the file as unicode format.(Actually we usually save the file as default ANSI format). For this format how can I execute it in sql plus successfully, you will get the error when doing that.
Re: How to execute unicode format SQL script [message #204825 is a reply to message #204803] Wed, 22 November 2006 04:47 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Quote:
you will get the error when doing that.

What exact error do you get?
Re: How to execute unicode format SQL script [message #204947 is a reply to message #204825] Wed, 22 November 2006 18:29 Go to previous messageGo to next message
Spark_Hong
Messages: 9
Registered: November 2006
Junior Member
The error will be:
-------------------------------------------------
SQL> @ora_issue_uc.sql
SP2-0042: unknown command " ■D" - rest of line ignored.
SQL>
-------------------------------------------------

Sql Plus don't recognize the unicode format file.

Thanks,
Spark
Re: How to execute unicode format SQL script [message #204987 is a reply to message #204947] Thu, 23 November 2006 00:18 Go to previous message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So the solution is obvious: do not save your SQL scripts in unicode format.
Previous Topic: Picking numbers from a character value
Next Topic: filling up missing records query
Goto Forum:
  


Current Time: Tue Dec 06 00:05:10 CST 2016

Total time taken to generate the page: 0.08978 seconds