Sanna B wrote:
> Hi all,
>
> I am a newbie, trying to run this procedure and get Invalid Procedure
> error.
>
> The procedure compiles without errors and returns the number of
> records as required. When attempting to execute - I get errors. Any
> ideas?
>
> Thanks,
> Sanna
>
> (Running 8i - pl/sql 8.1.7.0.0)
>
> here's the script:
> ---------------------------------------------------
> --comments start here
> --set serveroutput on
>
> create or replace proc testSB
> is
>
> declare
>
> vcount number;
>
> begin
>
> SELECT count(*) into vcount from testdba.test;
>
> dbms_output.put_line('count records:'||vcount);
>
> end;
> /
commit;
/
Received on Sun Aug 03 2003 - 21:27:22 CDT
