Procedure Builder: where do I define cursors?
From: Walter Dnes <waltdnes_at_interlog.com>
Date: Fri, 28 May 1999 05:15:26 GMT
Message-ID: <374e1e75.11866309_at_news.interlog.com>
Our group recently got me a licence for Procedure Builder Win95 client-side version (a subset of Dev2000 2.1). I've managed to re-do some packages/functions that I had previously done "the hard way" with raw SQL/PLUS. I'm now getting more ambitious and want to go on to bigger projects, which is the justification for buying Procedure Builder in the first place. My current problem is trying to define a cursor for use in a Procedure. I call up the Program Unit Editor, select the "Procedure" radio-button. I get a screen like so...
Procedure foo is
CURSOR BAR IS SELECT...
Date: Fri, 28 May 1999 05:15:26 GMT
Message-ID: <374e1e75.11866309_at_news.interlog.com>
Our group recently got me a licence for Procedure Builder Win95 client-side version (a subset of Dev2000 2.1). I've managed to re-do some packages/functions that I had previously done "the hard way" with raw SQL/PLUS. I'm now getting more ambitious and want to go on to bigger projects, which is the justification for buying Procedure Builder in the first place. My current problem is trying to define a cursor for use in a Procedure. I call up the Program Unit Editor, select the "Procedure" radio-button. I get a screen like so...
Procedure foo is
BEGIN END;
I'm trying to insert a cursor definition, e.g.
CURSOR BAR IS SELECT...
blah; blah; blah;
===================
...into the procedure and I'm not having any luck compiling. I'm a newbie to Procedure Builder, so it may be something really simple. How do I succesfully define an explicit cursor? I'd appreciate a hand-holding example the first time.
-- Walter Dnes <waltdnes_at_interlog.com> procmail spamfilter http://www.interlog.com/~waltdnes/spamdunk/spamdunk.htm Why a fiscal conservative opposes Toronto 2008 OWE-lympics http://www.interlog.com/~waltdnes/owe-lympics/owe-lympics.htmReceived on Fri May 28 1999 - 07:15:26 CEST