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_at_news1.elcjn1.sdca.home.com>
Date: Thu, 25 Oct 2001 01:44:40 GMT
Message-ID: <c8KB7.1001$yV.602860_at_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 Thu Oct 25 2001 - 03:44:40 CEST