Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: Closing cursors after leaving them open.
On Wed, 23 Jan 2002, damorgan_at_exesolutions.com wrote:
> DECLARE
>
> CURSOR xyz IS
> blah blah blah;
>
> BEGIN
> OPEN xyz;
> do some stuff;
> CLOSE xyz;
> END;
> /
I'm not looking for the correct syntax for opening and closing cursors for blocks of PL/SQL.
In an anonymous PL/SQL block which I submitted through sqlplus, I didn't close a cursor. I now am trying to find the way to reference that already open cursor in the current sqlplus session and close it. I was just considering that a current sqlplus session should be able to reference any cursor it might have already opened, even if it has already submitted a PL/SQL block which opened it. I certainly can't open it again, cause Oracle tells me it is already opened. But, I'm not sure how to tell Oracle to close it now that the anonymous block has been submitted.
I have always developed any Triggers or Stored Procs using a GUI and this time I was trying it with SQLPlus, cause I use Emacs and I stumbled onto a nice sql.el mode for it. I wanted to use Emacs if the mode was helpful enough cause I do most everything else there. I also see Mr. Kyte using sqlplus as though it is his primary environment and I would rather do it that way cause I'm always trying out what he posts here and on his site.
> Oh BTW ... did you actually try to find the answer in an Oracle
> book or were you just guessing at the syntax?
Daniel, I'm sorry you feel I posted a stupid or lazy question but I do read alot and search the newsgroups constantly, as well as Jonathan's FAQ and AskTom as well as many others. I have answered quite a few questions in this group and the answers should point to the fact that I read the documentation. There are times when I definitely do not understand it, but I don't believe I bother the group very often and I never just fire off a question cause I'm lazy. (although I haven't been active in this group lately because of other committments) What I was actually trying out where some of the cool things Mr. Kyte has in his one-on-one book. I am going to be doing _alot_ of PL/SQL development now and I wanted to use the best as a guide.
-- Galen deForest Boyer Sweet dreams and flying machines in pieces on the ground. ========= WAS CANCELLED BY =======: From: Galen Boyer <galenboyer_at_hotpop.com> Control: cancel <u4rl8vi15.fsf_at_rcn.com> Subject: cmsg cancel <u4rl8vi15.fsf_at_rcn.com> Date: Sun, 27 Jan 2002 23:57:15 GMT Message-ID: <cancel.u4rl8vi15.fsf_at_rcn.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.media.kyoto-u.ac.jp!newsfeed.mesh.ad.jp!newsfeed2.kddnet.ad.jp!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40720704 This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.Received on Sat Jan 26 2002 - 13:54:04 CST