HELP!Oracle Store Procedure

From: <cosmogong_at_my-dejanews.com>
Date: Wed, 13 May 1998 14:03:30 GMT
Message-ID: <6jc97h$sae$1@nnrp1.dejanews.com>

I am quite new to oracle store procedure. I logged in using my login name and password and try to create a simple procedure: CREATE OR REPLACE PROCEDURE test_proc AS BEGIN
SELECT * FROM ORADBA.table_name;
END; and oracle complained that ORADBA.table_name must be declared first.

I don't know why it is so and I also wonder if this will return me a recordset. I read something about cursors. Do I have to use a cursor?

Many thanks.

Cosmo

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed May 13 1998 - 09:03:30 CDT