By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,046 Members | 2,058 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,046 IT Pros & Developers. It's quick & easy.

getting error : PLS-00553: character set name is not recognized

P: 1
Hi

I am getting the following error when I tried to run the code given below

ORA-06550: line 1, column 29:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated

can anyone explain me why am getting such error and how to resolve it...

Please help me, Urgent...

Thanks in Advance

Prakash


declare
cursor c1 is select distinct Table_name
from all_tab_columns where column_name ='ACCOUNT_ID' and
OWNER ='Table_owner';
TNAME ALL_TAB_COLUMNS.TABLE_NAME%TYPE;
nrows number(3) := 0;
sQuery varchar2(500) ;
BEGIN
sQuery := '';
OPEN C1;
loop
FETCH C1 INTO TNAME;
EXIT WHEN c1%NOTFOUND;
sQuery := 'Select count(*) from ' || TNAME || ' where Account_id like ''BE%''';
EXECUTE IMMEDIATE sQuery into nrows;
-- nrows := Sql%rowcount;
dbms_output.put_line ('Table_name :' || tname ||' ' ||'has '|| nrows || ' rows');
end loop;
end;
/
May 26 '06 #1
Share this Question
Share on Google+
1 Reply


P: 2
Hi

I am getting the following error when I tried to run the code given below

ORA-06550: line 1, column 29:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated

can anyone explain me why am getting such error and how to resolve it...

Please help me, Urgent...

Thanks in Advance

Prakash


declare
cursor c1 is select distinct Table_name
from all_tab_columns where column_name ='ACCOUNT_ID' and
OWNER ='Table_owner';
TNAME ALL_TAB_COLUMNS.TABLE_NAME%TYPE;
nrows number(3) := 0;
sQuery varchar2(500) ;
BEGIN
sQuery := '';
OPEN C1;
loop
FETCH C1 INTO TNAME;
EXIT WHEN c1%NOTFOUND;
sQuery := 'Select count(*) from ' || TNAME || ' where Account_id like ''BE%''';
EXECUTE IMMEDIATE sQuery into nrows;
-- nrows := Sql%rowcount;
dbms_output.put_line ('Table_name :' || tname ||' ' ||'has '|| nrows || ' rows');
end loop;
end;
/
I have the same problem and can't find a solution for in on the internet, did anybody solve this issue?

hans
Oct 11 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.