473,327 Members | 1,920 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

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

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
1 5509
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

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

Similar topics

0
by: anuradha.k.r | last post by:
hi, i have written a simple socket program in python to connect to a windows machine.On the server side i am running a windows socket program which works perfectly fine,my server program waites at...
2
by: William Gower | last post by:
I am trying to display a page that has a data grid on it. I get this message Description: An error occurred during the processing of a configuration file required to service this request....
1
by: joseph pattom | last post by:
Hi all i am using <customErrors mode="On" defaultRedirect="ErrorDisplay.aspx"/> in my web.config file and getting redirected to "ErrorDisplay.aspx" in almost all the unhandled exceptions but in...
5
by: velu | last post by:
Problem in getting value from textbox & radiobuttonlist to a valuable inside a datagid. I want to insert a record into a table thru datagrid. Here is the code (see below) Private Sub...
1
by: sethuganesh | last post by:
HI, i have ported vc++ 6.0 code to visual studio 2005. During batch build in debug mode i din't get any error.But if i build the same in release mode i am getting the following error. ...
3
by: MuZZy | last post by:
Hi, I'm trying to run Windows Communication Foundation examples included with .NET 3 SDK and I'm getting error: The requested service, "http://localhost/servicemodelsamples/service.svc"...
2
by: soma.gunasekaran | last post by:
Hi All , I've stored the Image file..... But i want to retriving the Image files from MSACCSS 2003 (JPEG,bmp,Gif and etc....) So Pls help me........ help me............... Thanking you,...
2
by: dine123kumar | last post by:
Pls help me, Give me code for getting the data from MS Access to combo box which is using in VB6, I tried i in many ways but it giving the error msg (data convertion....) I am doing the project...
1
by: siddu | last post by:
Hi All, I have to do one task. First i need to copy files from vss and run bat files.i have a document with all steps. step 1: we have to take files from vss by using getlatestversion...
4
by: nani2717 | last post by:
HI ALL, I m currenly working with a visual basic 6 project.i m new to VB.wen i tried to comile a file i got the error "user defined type not defined".i don know wat appropriate reference to add.i m...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.