hi padmam,
thanks for your reply but again i am having some problems .....
whenever i am executing a PL/SQL for which i am using dbms_output.put_line('some message') for which i have to use SET SERVEROUTPUT ON. after setting when i try to execute the PL/SQL block it returns the error given below ,
this error persists till i issue
SET SERVEROUTPUT OFF
it returns same error while performing any DML operation
however please note select runs perfectly
the error is given below
--------------------------------------------
SQL> insert into emp(empno,ename,deptno)
2 values(1,'q',10);
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

1 row created.
-----------------------------------------------------
regds