Problem running PL/SQL Procedure

From: Sanna B <sannabr_at_ozonline.com.au>
Date: 3 Aug 2003 19:06:08 -0700
Message-ID: <f32b3694.0308031806.11a9c168@posting.google.com>

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;
/

---

SQL>@ C:\_work\sql\test_proc.sql
count records:185119

PL/SQL procedure successfully completed.

---

SQL> exec testSB
BEGIN testSB; END;

      *
ERROR at line 1:

ORA-06550: line 1, column 7:
PLS-00201: identifier 'TESTSB' must be declared
ORA-06550: line 1, column 7:

PL/SQL: Statement ignored Received on Sun Aug 03 2003 - 21:06:08 CDT