Home » SQL & PL/SQL » SQL & PL/SQL » character set name is not recognized (Oracle 8i, Windows xp)
character set name is not recognized [message #306674] Sat, 15 March 2008 12:46 Go to next message
gargi_12300
Messages: 11
Registered: March 2008
Junior Member
hey I am having a problem.
ERROR at line 1:
ORA-06550: line 1, column 122:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
my procedure code is written below:
create or replace procedure adduser(cit_name in Citizen_personal.Citizen_name%TYPE,
cit_add in Citizen_personal.address%TYPE,
cit_po in Citizen_personal.Post_office%TYPE,
cit_pin in Citizen_personal.Pin_code%TYPE,
cit_age in Citizen_personal.Age%TYPE,
cit_sex in Citizen_personal.Sex%TYPE,
cit_occ in Citizen_personal.Occupation%TYPE,
cit_an_inc in Citizen_personal.Annual_income%TYPE,
cit_phy in Citizen_personal.Physically_disable_status%TYPE,
cit_bpl in Citizen_personal.BPL_status%TYPE,
cit_house in Citizen_personal.Household_status%TYPE,
cit_lname in Citizen_personal.Legal_status_Name%TYPE,
cit_lnumber in Citizen_personal.Legal_status_number%TYPE,
cit_caste in Citizen_personal.Caste%TYPE,
cit_block in Citizen_personal.Block%TYPE,
u_id out varchar2)
is
part1 varchar2(20);
a1 varchar2(20);
b1 varchar2(30);
seq_num number(10);
a number(10);
cursor b_id is select blk_id,district from block_master where blk_name=cit_block;
begin
seq_num:=a-1;
open b_id;
loop
fetch b_id into a1,b1;
exit when b_id%NOTFOUND;
select count (*) into a from citizen_personal where Block=cit_block;
part1:=a1||'CTZ';
u_id:=part1||to_char(seq_num);
insert into Citizen_personal values(u_id,cit_name,cit_add,cit_po,b1,cit_pin,cit_age,cit_sex,cit_Occ,cit_an_inc,cit_phy,cit_bpl,cit_house,cit_lname,cit_lnumber,cit _caste,cit_block);
end loop;
close b_id;
commit;
end;
And the table I used is:

CITIZEN_ID VARCHAR2(20)
CITIZEN_NAME VARCHAR2(30)
ADDRESS VARCHAR2(30)
POST_OFFICE VARCHAR2(10)
DISTRICT VARCHAR2(10)
PIN_CODE NUMBER(8)
AGE NUMBER(3)
SEX VARCHAR2(6)
OCCUPATION VARCHAR2(50)
ANNUAL_INCOME NUMBER(8)
PHYSICALLY_DISABLE_STATUS VARCHAR2(8)
BPL_STATUS VARCHAR2(20)
HOUSEHOLD_STATUS VARCHAR2(8)
LEGAL_STATUS_NAME VARCHAR2(50)
LEGAL_STATUS_NUMBER VARCHAR2(20)
CASTE VARCHAR2(20)
BLOCK VARCHAR2(20)
I am using Oracle 8i on windows xp
plzz help me
I badly require the help...



Smileys disabled by moderator to make post slightly more readable.

[Updated on: Sat, 15 March 2008 12:53] by Moderator

Report message to a moderator

Re: character set name is not recognized [message #306675 is a reply to message #306674] Sat, 15 March 2008 12:47 Go to previous messageGo to next message
gargi_12300
Messages: 11
Registered: March 2008
Junior Member
those smileys must be replaced by 8!
Re: character set name is not recognized [message #306676 is a reply to message #306674] Sat, 15 March 2008 12:50 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
Are you in capable or unwilling to use GOOGLE yourself?
Results 1 - 10 of about 639 for PLS-00553: character set name is not recognized oracle
Re: character set name is not recognized [message #306678 is a reply to message #306676] Sat, 15 March 2008 13:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And to read OraFAQ Forum Guide, especially "How to format your post?" section.
This will learn how to avoid these smileys in the code.

Regards
Michel
Re: character set name is not recognized [message #306679 is a reply to message #306676] Sat, 15 March 2008 13:05 Go to previous messageGo to next message
gargi_12300
Messages: 11
Registered: March 2008
Junior Member
I have used it but I found no solutions
I am still left with the same problem
Re: character set name is not recognized [message #306682 is a reply to message #306679] Sat, 15 March 2008 13:26 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
PLS-00553: character set name is not recognized
Cause: An unrecognized name appears in a character set specification.
Action: Change or remove the character set specification.


Regards
Michel
Previous Topic: Pull Data from Lotus Notes into Oracle server
Next Topic: To retrieve first characters before period
Goto Forum:
  


Current Time: Sat Dec 03 16:25:59 CST 2016

Total time taken to generate the page: 0.10432 seconds