|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
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
|
|||
|
|||
|
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 |
|
#2
|
|||
|
|||
|
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. |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Dbms_output.put_line() Problem. |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|