stored procedures in oracle

From: <urpukka_at_my-deja.com>
Date: Fri, 29 Dec 2000 12:29:55 GMT
Message-ID: <92i041$74d$1@nnrp1.deja.com>

Hi!

I have tried to make a stored procedures with Oracle SQL*Plus.

CREATE OR REPLACE PROCEDURE OPET AS
BEGIN
SELECT KJ1.KJGP0SSI.SIGNATUR,KJ1.KJGP0PER.EFTERNAMN,KJ1.KJGP0PER.FORNAMN FROM KJ1.KJGP0PER, KJ1.KJGP0SSI
WHERE KJ1.KJGP0PER.PERSONNR = KJ1.KJGP0SSI.PERSONNR; END;
/

This procedure was created with compilation errors: LINE/COL ERROR

-------- -------------------------------------------------
3/1      PL/SQL: SQL Statement ignored
4/6      PLS-00201: identifier 'KJ1.KJGP0PER' must be declared

What is the problem?

Sent via Deja.com
http://www.deja.com/ Received on Fri Dec 29 2000 - 06:29:55 CST