about plsql703b1

[Chip]

I am working with plsql70 not support unicode, so I used plsql703b1, I see it good when export to MS Excel and view Result good in grid unicode. But when I edit my package it failure, some information lost while plsql7.0 has not any problem. Please help me!!!!!!!!!!!!!!

 

[Marco Kalter]

I'm not quite sure what you mean by "when I edit my package it failure". Can you elaborate a bit?

 

[Chip]

Thank for answer my question
Example I create one package in SQL*PLUS
(user SCOTT):

CREATE OR REPLACE package EMPPK is
function DeptNo(V_EmpNo Number) return Number;
end EMPPK;
/
CREATE OR REPLACE package body EMPPK is
function DeptNo(V_EmpNo Number) return Number is
V_Temp Number;
Begin
Select DeptNo Into V_Temp
From Emp Where Emp.Empno = V_EmpNo;
Return V_Temp;
Exception
When OThers Then Return Null;
End;
end EMPPK;
/

Open that package in PL/SQL703b1 is this:

create or replace package EMPPK is
function DeptNo(V_EmpNo Number) return Number;
end EMPPK

create or replace package body EMPPK i
function DeptNo(V_EmpNo Number) return Number is
V_Temp Number
Begi
Select DeptNo Into V_Temp
From Emp Where Emp.Empno = V_EmpNo
Return V_Temp
Exceptio
When OThers Then Return Null;
End;
end EMPPK

Some Information is truncated
package body EMPPK is => package body EMPPK i
Begin => Begi
Exception => Exceptio
...
But In PLSQL7.0 is good. Hic hic

 

[Marco Kalter]

Can you let me know the following information?

• The value of your NLS_LANG key in the Oracle registry.
• The value of your NLS_NCHAR key in the Oracle registry.
• The results of the following query:
  select * from nls_database_parameters
  where parameter like 'NLS%CHARACTERSET'

 

[Chip]

select * from nls_database_parameters
where parameter like 'NLS%CHARACTERSET'

=>
NLS_CHARACTERSET UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16

In Registry of MS XP:
NLS_LANG: AMERICAN_AMERICA.UTF8

But I think it not affect to edit package.

 

[Marco Kalter]

I was able to reproduce this problem on an UTF-8 database. It is fixed, and we'll have a new 7.0.3 beta available shortly.

 

[Chip]

In 7.0.3b2 It good, tks.