Re: Newbie ? - Howto find nbr records in a table

Sorry,

     The line you type in SQL Plus should be:

SQL> VARIABLE jay NUMBER

not:

SQL> VARIABLE v_jay NUMBER...

Jay!!!

Jason Jay Weiland wrote:

> [snip]
> Then in SQL Plus:
> SQL> @c:\temp\count
> Procedure created.
> No errors.
> SQL> VARIABLE v_jay NUMBER
> SQL> execute pr_count('FOO', :jay);
> PL/SQL procedure successfully completed.
> SQL> print jay;
> JAY
> ---------
> 107
Received on Tue Oct 06 1998 - 13:49:22 CDT