OraFAQ Forum: Spatial » Problem with cursors

Home » Server Options » Spatial » Problem with cursors (oracle 10g)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Problem with cursors [message #335097]

Mon, 21 July 2008 00:20

dilforyou
Messages: 2
Registered: July 2008

Junior Member

Hi,
I create procedure by using spatial netwrok models.In that procedure i used below package

sdo_net_mem.network_manager.all_paths

that procedure opening cursors but its not closing.
due to this i am unable to populate data without restarting the service.

is it possible to close all cursors without restarting service.

Thanks in advance

Report message to a moderator

Re: Problem with cursors [message #339377 is a reply to message #335097]

Thu, 07 August 2008 06:54

kmanikandanbe
Messages: 1
Registered: August 2008

Junior Member

hi dileep,
if u want without restarting the service mean.,u can close the session....
When u close the session ,then the cursor value will be reset...

by
cool Smile

Report message to a moderator

Previous Topic:	How to close cursors
Next Topic:	Overlapping polygon and how to determine the points

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 20 02:48:53 CDT 2013

Total time taken to generate the page: 0.11210 seconds