Re: Increment at counter

From: Matt B. <gtimatt_at_home.com>
Date: Thu, 25 Oct 2001 01:44:40 GMT
Message-ID: <c8KB7.1001$yV.602860@news1.elcjn1.sdca.home.com>

"GREGORY KNESER" <gregoryk_at_futures.wharton.upenn.edu> wrote in message news:9r6pqb$sp$2_at_netnews.upenn.edu...
> Changes below:
> : dbms_output.put_line('1. || v_counter || ' records inserted.');

This change too:

dbms_output.put_line('1. '||to_char(v_counter)||' records inserted.');

Otherwise you'd get a literal string of v_counter in the output and not the value of v_counter. Not sure if the TO_CHAR is necessary but I've had issues concatenating different datatypes before and it can't hurt.

-Matt Received on Wed Oct 24 2001 - 20:44:40 CDT