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

[prakash.appidi]

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;
/

[hansgso]

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