Database link: Wrong column length from cursor
From: Dmitry Duginov <me_at_duginov.com>
Date: 15 Dec 2003 16:04:23 -0800
Message-ID: <c240fbad.0312151604.398d9bd6_at_posting.google.com>
set serveroutput on
DECLARE
CURSOR cur is select ed_no, length(ed_no) as len from listtext_at_pubdb.world; BEGIN
Date: 15 Dec 2003 16:04:23 -0800
Message-ID: <c240fbad.0312151604.398d9bd6_at_posting.google.com>
Here's a problem
set serveroutput on
DECLARE
CURSOR cur is select ed_no, length(ed_no) as len from listtext_at_pubdb.world; BEGIN
for cur_rec in cur
loop
DBMS_OUTPUT.PUT_Line
('>'||cur_rec.ed_no||'<'||to_char(cur_rec.len) );
end loop;
end;
/
this returns
>ABC <3
>XYZ <3
...
Any comments, suggestions, workarounds, please... This bug (I believe
it's a bug) gonna ruin a month of my work :(((
I NEED the database link and I cannot employ RTRIM() everywhere.
Regards,