Executing procedures

From: <simonbach_at_my-deja.com>
Date: Tue, 14 Dec 1999 11:51:24 GMT
Message-ID: <835avr$th4$1@nnrp1.deja.com>

I have not really used the SQL/PL in oracle before , but I have written in other SQL languages. I have used the Oracle Migration WorkBench to migrate a database over from MSQL Server and this worked well. I managed after some manipulation to get 78 stored procedures across ( all of the ones that I needed ). I have written stored procedures as tests before and tried to run them in SQL*Plus , but only the without parameters or recordsets being returned seem to work even though they are valid the actual execution in SQL*Plus does not seem to work.

A typical example of the code I am running is below:

SPCASESDISTPkg PACKAGE CODE :

AS
TYPE RT1 IS RECORD (

	acronym		rtpes.acronym%TYPE --
	name		rtpes.name%TYPE    --
	);

TYPE RCT1 IS REF CURSOR RETURN RT1 ; END;

---

PROCEDURE CODE : (
RC1 IN OUT SPCASESDISTPkg.RCT1)
AS

Sto0_selcnt	INTEGER;
Sto0_error	INTEGER;
Sto0_rowcnt	INTEGER;
Sto0_crowcnt	INTEGER := 0;
Sto0_fetchstatus	INTEGER := 0;
Sto0_errmsg	varchar2(255);
Sto0_sqlstatus	INTEGER;
BEGIN
	OPEN RC1 FOR
	SELECT acronym, rtpes.name FROM rtpes;
	RETURN;

END spCasesDist;

---

How do I execute this procedure in SQL*Plus in order to return a recordset.

I am sorry about the simplicity of the problem , but I am just a beginner to this and I have to start somewhere.

Any help will be extremely appreciated.

Michael O'Sullivan

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 14 1999 - 05:51:24 CST