-Madhu
How about the following:
create or replace PROCEDURE Get_Emp_Rows (EmpCur IN OUT GenPack.GenCurTyp,
Nstr Varchar2) IS
cname Emp.Name%type;
rec_count number; -- == I added this
BEGIN
select count(*) into rec_count -- == I added these
FROM Emp where name = Nstr;
recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: refcursor rowcount check
Date: Mon, 22 Apr 2002 05:03:22 -0800
-Madhu
How about the following:
create or replace PROCEDURE Get_Emp_Rows (EmpCur IN OUT GenPack.GenCurTyp,
Nstr Varchar2) IS
cname Emp.Name%type;
rec_count number
]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: refcursor rowcount check
Date: Mon, 22 Apr 2002 05:03:22 -0800
-Madhu
How about the following:
create or replace PROCEDURE Get_Emp_Rows (EmpCur IN OUT GenPack.GenCurTyp,
Nstr Varchar2) IS
cname Emp.Name%type;
rec_count
of the immediate reqts
is to return 'input' customer's trading activity - which can vary widely)
regards
Madhu
From: Mercadante, Thomas F [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: refcursor rowcount check
Date: Mon, 22 Apr 2002 09
List,
I'm having a small problem while checking row count parameter in a
refcursor.
A stored procedure accepts parameters and returns refcursors; if no
candidate rows are found, then an error code is returned to the calling
program. The same cursor variable is used to retrun the rowset or