I am trying to display values from oracle to client appln.
I have a database field called STRNAME, datatype is varchar2(255), contains few hundreds of records. I have written a procedure to display the name,
Name: Proc 1
create or replace procedure test(aNum out varchar2) AS
cursor sample_cursor is select strname from sample1 ;
fetch sample_cursor into total;
fetch sample_cursor into sample_rec;
exit when sample_cursor%notfound;
total := total || '+' || sample_rec;
aNum := total;
Name: test1.sql PL/SQL to execute the above proc
set serveroutput on
My output is,
when i execute the test1.sql i got the following errors,
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_OUTPUT", line 64
ORA-06512: at line 6
I do now know where exactly the problem is. The data can be combination of chars and spl chars. I have doubt like is it related to string buffer is insuffient.
I am looking for your great help.
DBMS_OUTPUT.PUT_LINE(a) can print only 255 characters per line.
Try check it :
Click Here to Expand Forum to Full Width