Cursing over cursors!

From: Frampton Steve R <3srf_at_qlink.queensu.ca>
Date: 1995/07/18
Message-ID: <3ugs04$ai3_at_knot.queensu.ca>#1/1

Hello:

I'm new to PL/SQL, and am having a little difficulty with cursors. Now that I finally understand them, I need a little help writing one.

I want to do calculations in my select statement inside the cursor, and have the results placed in my target variables. In straight PL/SQL, I would have something like:

select to_date(exception_start_date,'YYMMDD') into start
from absence_exception_table;

Of course, you can't do an "INTO" in cursors. I've also tried:

select to_date(exception_start_date,'YYMMDD') start from absence_exception_table;

...but I got an error for this too.

What is the proper way of doing this? I've only got access to Oracle's PL/SQL User's Guide & Reference, and this manual is worse than the famous cruddy manuals for Borland products!

Any information would be appreciated. Thanks in advance!

-----------------------------------+-----------------------------------------

Steve Frampton                     | Phone:    (613) 547-5987, ext. 312 or 331

Computer Operator/Systems Clerk | Internet: frampton_at_admin.flarc.edu.on.ca Frontenac-Lennox & Addington RCSSB | DECNET: FLASSB::FRAMPTON
-----------------------------------+-----------------------------------------
Received on Tue Jul 18 1995 - 00:00:00 CEST