How to close a cursor   Independent houses near kukatpally | Apartments in Pragathi Nagar | AndhraVaani.com | Log Out | Topics | Search
Register | Edit Profile

Bewarse TalkArchives - 2007Cine Talk - Reviews, Gossips, Insider Info etc.Archive through July 23, 2007How to close a cursor Previous Next

Author Message
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3160
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 3:49 pm:Edit PostDelete PostView Post/Check IP

ilanti questions valla memantha knowledge penchukuntunnam, repu gochi koda cursor ni close sesethadu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Fubar
Kurra Bewarse
Username: Fubar

Post Number: 1032
Registered: 11-2006
Posted From: 192.44.136.113

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 3:12 pm:Edit PostDelete PostView Post/Check IP

motham btdb vaalatho work chepinchi denxguthunaadu ga pills gaadu
You've got to ask yourself one question: 'Do I feel lucky?' Well, do ya punk?
Top of pagePrevious messageNext messageBottom of pageLink to this message

Bignole
Mudiripoyina Bewarse
Username: Bignole

Post Number: 5986
Registered: 03-2004
Posted From: 161.225.1.12

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 3:11 pm:Edit PostDelete PostView Post/Check IP

hemu ga
No Signature
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3159
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:49 pm:Edit PostDelete PostView Post/Check IP

ayithe correct kadannamata ante sessions lo naa vere window loni select statements konni chotla choyinchindi, so session ante manam toad lo open chesindega anukunna inka. hmm. kaani work ayyindi close cheyyagane. toad close chesetappudu commit seyyana vadha andi, vadhu anna. leda kasepatiki adi inactive ayyindemo nayak seppinattu. emo edo ayyindi kani final ga work ayyindi. :-)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Pokiri1
Mudiripoyina Bewarse
Username: Pokiri1

Post Number: 8032
Registered: 03-2006
Posted From: 152.123.2.230

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:46 pm:Edit PostDelete PostView Post/Check IP

nee yenks hemu.malli correct kadaa ani adugu tunnavu
You're never too old to become younger.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 42904
Registered: 07-2004
Posted From: 162.136.192.1

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:41 pm:Edit PostDelete PostView Post/Check IP

naa session close chestham ante naa toad close chesthamenemo ani toad close sesaa. malla open sethunna


school kelli sadavaledu 123....ninnu choosi nerchukunna 143
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3158
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:28 pm:Edit PostDelete PostView Post/Check IP



nayak mama thanks mama session close cheyyali ani idea ichinanduku.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sinnodu
Yavvanam Kaatesina Bewarse
Username: Sinnodu

Post Number: 4081
Registered: 05-2005
Posted From: 192.58.204.226

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:27 pm:Edit PostDelete PostView Post/Check IP

bemmam maaya
Dont show me ur attitude.I have got my own
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3157
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:26 pm:Edit PostDelete PostView Post/Check IP

enti correst kaada work ayyindehee.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Pokiri1
Mudiripoyina Bewarse
Username: Pokiri1

Post Number: 8031
Registered: 03-2006
Posted From: 152.123.2.230

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:18 pm:Edit PostDelete PostView Post/Check IP

/naa session close chestham ante naa toad close chesthamenemo ani toad close sesaa/

You're never too old to become younger.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3156
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:16 pm:Edit PostDelete PostView Post/Check IP

run avuthundi nayak mama
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3155
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:16 pm:Edit PostDelete PostView Post/Check IP

naa session close chestham ante naa toad close chesthamenemo ani toad close sesaa. malla open sethunna. aagu septha findings.

sare bojananiki elli raa
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Mudiripoyina Bewarse
Username: Nayakudu

Post Number: 8608
Registered: 05-2005
Posted From: 148.107.10.20

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:09 pm:Edit PostDelete PostView Post/Check IP

kalki mama maa employer naa dabbulu naku isthey chalu... aademma DNK gadu... expense pay cheyyaka pothenaa migilina 18 USD vadini
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Mudiripoyina Bewarse
Username: Nayakudu

Post Number: 8607
Registered: 05-2005
Posted From: 148.107.10.20

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:08 pm:Edit PostDelete PostView Post/Check IP

hemu mayya ippatiki auotomatic ga invalid ayyi vuntadi aa cursor.. ippudu select kotti chudu work ayyiddi
Top of pagePrevious messageNext messageBottom of pageLink to this message

Kalki
Bewarse Legend
Username: Kalki

Post Number: 13909
Registered: 04-2005
Posted From: 129.33.49.251

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:08 pm:Edit PostDelete PostView Post/Check IP

naakudu gaa pils gadini okka $1000 ampamanu...tega questions adugutunnadu ga ninnu
Bewarse Legend KALKI - The Un-Expected
Top of pagePrevious messageNext messageBottom of pageLink to this message

Pedarayudu
Pilla Bewarse
Username: Pedarayudu

Post Number: 418
Registered: 04-2007
Posted From: 129.138.18.85

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:08 pm:Edit PostDelete PostView Post/Check IP

nannu cheminchu baa.. roju kalakesh adagatam nuvvu parigettuku ellatam soosi jila aapukolekapoyaa
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Mudiripoyina Bewarse
Username: Nayakudu

Post Number: 8606
Registered: 05-2005
Posted From: 148.107.10.20

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:07 pm:Edit PostDelete PostView Post/Check IP

peda baa
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Mudiripoyina Bewarse
Username: Nayakudu

Post Number: 8605
Registered: 05-2005
Posted From: 148.107.10.20

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:06 pm:Edit PostDelete PostView Post/Check IP

Database user.. ye DB user lo nundi SQL run chesavoo aa user
Top of pagePrevious messageNext messageBottom of pageLink to this message

Kalki
Bewarse Legend
Username: Kalki

Post Number: 13908
Registered: 04-2005
Posted From: 129.33.49.251

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:05 pm:Edit PostDelete PostView Post/Check IP

PeDA ga u intelligent vater
Bewarse Legend KALKI - The Un-Expected
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Mudiripoyina Bewarse
Username: Nayakudu

Post Number: 8604
Registered: 05-2005
Posted From: 148.107.10.20

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:05 pm:Edit PostDelete PostView Post/Check IP

locks tab lo kuda chudu mayya
Top of pagePrevious messageNext messageBottom of pageLink to this message

Pedarayudu
Pilla Bewarse
Username: Pedarayudu

Post Number: 417
Registered: 04-2007
Posted From: 129.138.18.85

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:04 pm:Edit PostDelete PostView Post/Check IP

VNMG correct gane seppana
Top of pagePrevious messageNext messageBottom of pageLink to this message

Maanas
Mudiripoyina Bewarse
Username: Maanas

Post Number: 6313
Registered: 08-2006
Posted From: 203.91.207.30

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:04 pm:Edit PostDelete PostView Post/Check IP

DB user

ante
Only item in the world that will never hurt u is work.Love ur work,It will never hurt u like ur last girlfriend - churaech
Top of pagePrevious messageNext messageBottom of pageLink to this message

Kalki
Bewarse Legend
Username: Kalki

Post Number: 13907
Registered: 04-2005
Posted From: 129.33.49.251

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:04 pm:Edit PostDelete PostView Post/Check IP

naakudu gaa daa......................


pill in the blank
Bewarse Legend KALKI - The Un-Expected
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3154
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:03 pm:Edit PostDelete PostView Post/Check IP

nayak mama aagu chostha.

big hater. aagehee
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Mudiripoyina Bewarse
Username: Nayakudu

Post Number: 8603
Registered: 05-2005
Posted From: 148.107.10.20

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:03 pm:Edit PostDelete PostView Post/Check IP

nenu jump intiki lunch ki
Top of pagePrevious messageNext messageBottom of pageLink to this message

Maanas
Mudiripoyina Bewarse
Username: Maanas

Post Number: 6312
Registered: 08-2006
Posted From: 203.91.207.30

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 2:01 pm:Edit PostDelete PostView Post/Check IP

..
Only item in the world that will never hurt u is work.Love ur work,It will never hurt u like ur last girlfriend - churaech
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 42902
Registered: 07-2004
Posted From: 162.136.192.1

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 1:59 pm:Edit PostDelete PostView Post/Check IP


school kelli sadavaledu 123....ninnu choosi nerchukunna 143
Top of pagePrevious messageNext messageBottom of pageLink to this message

Bignole
Mudiripoyina Bewarse
Username: Bignole

Post Number: 5985
Registered: 03-2004
Posted From: 161.225.1.12

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 1:58 pm:Edit PostDelete PostView Post/Check IP

Hemu ga nee billing entha annav?
No Signature
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Mudiripoyina Bewarse
Username: Nayakudu

Post Number: 8602
Registered: 05-2005
Posted From: 148.107.10.20

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 1:58 pm:Edit PostDelete PostView Post/Check IP

OS user, DB user, host machine , date , active/inactive anni vuntayiii anni use chesi nee session yento chudu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Mudiripoyina Bewarse
Username: Nayakudu

Post Number: 8601
Registered: 05-2005
Posted From: 148.107.10.20

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 1:58 pm:Edit PostDelete PostView Post/Check IP

by user and machine vuntadi chudu mayya...
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Mudiripoyina Bewarse
Username: Nayakudu

Post Number: 8600
Registered: 05-2005
Posted From: 148.107.10.20

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 1:56 pm:Edit PostDelete PostView Post/Check IP

790 anni active kadumayya.. just select active sessions
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3153
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 1:53 pm:Edit PostDelete PostView Post/Check IP

DBA ki velli sessions lo open cursors ani undi maaya. kaani andulo 790 daaka unnayi :-( denemma jeevitham okokkati chosthunna kanapadatam ledu :-(

edanna fast way unda??
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Mudiripoyina Bewarse
Username: Nayakudu

Post Number: 8599
Registered: 05-2005
Posted From: 148.107.10.20

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 1:50 pm:Edit PostDelete PostView Post/Check IP

The Kill/Trace window displays session information on the use of locks, blocking locks, and rollback segments. The Access tab lists objects by each user in the current session. You can also review the current statement and open cursors for each user. When necessary, you can selectively kill sessions using the Kill the selected session command from the Kill/Trace toolbar
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Mudiripoyina Bewarse
Username: Nayakudu

Post Number: 8598
Registered: 05-2005
Posted From: 148.107.10.20

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 1:49 pm:Edit PostDelete PostView Post/Check IP

option idi

DBA ---> Kill/Trace Session
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Mudiripoyina Bewarse
Username: Nayakudu

Post Number: 8597
Registered: 05-2005
Posted From: 148.107.10.20

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 1:48 pm:Edit PostDelete PostView Post/Check IP

TOAD lo view session information ani vuntadi .. yedo menu lo.. naa daggara toad ledu mayya.. aa option select cheyyagane oka window open ayyiddi.. dnailo active sessions ni chudu.. chusi select statement chudu each session ki.. cursor select kanapadagane aa session ni kill cheseyyi
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3152
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 1:46 pm:Edit PostDelete PostView Post/Check IP

ela kill seyyali nayak mama toad lo??

gochi maam, aa edava pani already sesa. thannindi. nayak seppindi right. kiki.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 42901
Registered: 07-2004
Posted From: 162.136.192.1

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 1:44 pm:Edit PostDelete PostView Post/Check IP

aithe ok nayakesh
school kelli sadavaledu 123....ninnu choosi nerchukunna 143
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Mudiripoyina Bewarse
Username: Nayakudu

Post Number: 8596
Registered: 05-2005
Posted From: 148.107.10.20

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 1:42 pm:Edit PostDelete PostView Post/Check IP

GOSI mayya malla view nundi data select cheyyali.. appudu mundu open aina cursor ni close cheyyali.. ante job ni kill cheyyali..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 42900
Registered: 07-2004
Posted From: 162.136.192.1

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 1:39 pm:Edit PostDelete PostView Post/Check IP

Close cursor ani command type sesi soosaava hemu maama
school kelli sadavaledu 123....ninnu choosi nerchukunna 143
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Mudiripoyina Bewarse
Username: Nayakudu

Post Number: 8593
Registered: 05-2005
Posted From: 148.107.10.20

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 1:39 pm:Edit PostDelete PostView Post/Check IP

ohhh jobs loki velli kill cheyyu aa cursor statement ni
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Mudiripoyina Bewarse
Username: Nayakudu

Post Number: 8592
Registered: 05-2005
Posted From: 148.107.10.20

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 1:38 pm:Edit PostDelete PostView Post/Check IP

CLOSE <cursor_name>
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3151
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, July 19, 2007 - 1:35 pm:Edit PostDelete PostView Post/Check IP

nenu oka view nunchi data select chesthunna. aa view oka package loni function ni call chesthundi. aa function lo oka curson open chesthundi.

nenu select operation madhyalo cancel chesaa. next malla select antante cursor open chesi undi already ani error vasthundi :-(

ippudu ee cursor ni ela close cheyyali??

ORA-06511: PL/SQL: cursor already open