Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Try It Free
Go Back   Dev Shed ForumsDatabasesOracle Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old January 11th, 2005, 01:30 AM
saiashok saiashok is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jan 2005
Posts: 1 saiashok User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via MSN to saiashok Send a message via Yahoo to saiashok
Dbms_output.put_line() Problem.

hI,
the following is the PL/SQL block i wrote:-

Code:-
-----
DECLARE
CURSOR c_ins IS
SELECT * FROM STUDENTS;
BEGIN
delete from student_new;
FOR v_ins IN c_ins LOOP
INSERT INTO student_new values(v_ins.id,v_ins.first_name,v_ins.last_name,
v_ins.major, v_ins.current_credits);
end loop;
insert into log_table values(3,'error 3','ah ah ah...error occured');
dbms_output.put_line('success om jai sairam');
commit;
end;
/


Error:-
-----
if i run the block, i get the following error.

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

PL/SQL procedure successfully completed.

SQL>


My question:-
------------

dbms_output.put_line() is not working. i tried
sql> set serveroutput on

Oracle 9i is the version i am using.

I guess i have given the maximum information abt my problem

Kindly get me a solution.

Ashok sp
Enjoy coding

Reply With Quote
  #2  
Old January 12th, 2005, 09:30 AM
jim mcnamara jim mcnamara is offline
......@.........
Dev Shed Beginner (1000 - 1499 posts)
 
Join Date: Jun 2004
Posts: 1,307 jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level)jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level)jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level)jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level)jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level)jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 1 Week 3 Days 4 h 28 m 57 sec
Reputation Power: 48
To use DBMS_OUTPUT:
Add -
SET SERVEROUT ON SIZE 1000000
at the top of the file

Before you call DBMS_OUTPUT.put_line() call
DBMS_OUTPUT.enable(1000000);

If I understand what you want ---
Your code is not even getting to the DBMS call. PLS 0553 means that (earlier, before you ran this code or as part of how you login) you changed NLS settings incorrectly.
This means your code is NOT even being run.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesOracle Development > Dbms_output.put_line() Problem.


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway