Q
Problem solve Get help with specific problems with your technologies, process and projects.

Character set name is not recognized

Would you please guide me on why I am getting these errors when I try to run the below script? 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.

Would you please guide me on why I am getting the following error:

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
when I try to run the below script:
declare
  cursor c1 is select distinct Table_name
  from all_tab_columns where column_name ='ACCOUNT_ID' AND OWNER ='SEAPARK';
  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;
/

Thanks in advance.

Your character set is not defined correctly. Check your setting for NLS_LANG. This can be define by an environment variable or with the ALTER SESSION command. This can also be set database-wide.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close