Re: Why doesn't this work - function failing?

Paul wrote:
> Paul <paul_at_see.my.sig.com> wrote:
>
>
> > I have a .csv dump routine (code at end of post) and it's not working.
>
>
> OK, I have this figured out. But a new problem has arisen.
>
>
> ----------------------------------------------------------------
> CREATE OR REPLACE procedure test_dump_csv
> as
> l_rows number;
> billy varchar2(30); <--------- Added line
> begin
> DBMS_OUTPUT.put_line('Here is OK'); <------- Added line
> l_rows := dump_csv( 'select * from scott.emp', ',', 'D:\Paul',
> 'test.csv');
> billy := TO_CHAR(l_rows); <------------ Added line
> DBMS_OUTPUT.put_line('Hi there' + billy); <---- Added line

        Replace + with || in the above line. I am sure it must be a typo :)

<snipped>

Regards
/Rauf Received on Fri Aug 12 2005 - 13:01:20 CDT