Today' cursor chitka   Independent houses near kukatpally | Apartments in Pragathi Nagar | AndhraVaani.com | Log Out | Topics | Search
Register | Edit Profile

Bewarse TalkArchives - 2007Bewarse Bewarse BewarseArchive through April 05, 2007 � Today' cursor chitka Previous Next

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

Nayakudu
Desanike Pedda Bewarse
Username: Nayakudu

Post Number: 6402
Registered: 05-2005
Posted From: 129.188.69.145

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

Posted on Friday, March 30, 2007 - 2:56 pm:Edit PostDelete PostView Post/Check IP

intiki d'dam anukunte pakka room lone BRM edchadu... ee roju ikkadiki vachhadu edava
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Desanike Pedda Bewarse
Username: Nayakudu

Post Number: 6401
Registered: 05-2005
Posted From: 129.188.69.145

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

Posted on Friday, March 30, 2007 - 2:55 pm:Edit PostDelete PostView Post/Check IP

PDA baa nee ganta paguluddi inko 30 secs lo ikkada post veyyaka pothey
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Desanike Pedda Bewarse
Username: Nayakudu

Post Number: 6400
Registered: 05-2005
Posted From: 129.188.69.145

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

Posted on Friday, March 30, 2007 - 2:54 pm:Edit PostDelete PostView Post/Check IP

ireland vallu ee vidham ga england meeda avenging anna mata
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Vooriki Bewarse
Username: Beer

Post Number: 2678
Registered: 09-2006
Posted From: 208.204.155.241

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

Posted on Friday, March 30, 2007 - 2:53 pm:Edit PostDelete PostView Post/Check IP

Ireland vallu ramp adatannaru england ni
Okkadunnadu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Desanike Pedda Bewarse
Username: Nayakudu

Post Number: 6399
Registered: 05-2005
Posted From: 129.188.69.145

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

Posted on Friday, March 30, 2007 - 2:53 pm:Edit PostDelete PostView Post/Check IP

ala use cheyyani vallaku idi andaru cursor for loop lu vadaru kada
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Vooriki Bewarse
Username: Beer

Post Number: 2677
Registered: 09-2006
Posted From: 208.204.155.241

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

Posted on Friday, March 30, 2007 - 2:52 pm:Edit PostDelete PostView Post/Check IP

ehesss.. ee sodi golanta enduku...


cursor for loop vadu..
Okkadunnadu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Desanike Pedda Bewarse
Username: Nayakudu

Post Number: 6398
Registered: 05-2005
Posted From: 129.188.69.145

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

Posted on Friday, March 30, 2007 - 2:51 pm:Edit PostDelete PostView Post/Check IP

sare mama neevoka chitka cheppuko bore d'thundi
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Desanike Pedda Bewarse
Username: Nayakudu

Post Number: 6397
Registered: 05-2005
Posted From: 129.188.69.145

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

Posted on Friday, March 30, 2007 - 2:50 pm:Edit PostDelete PostView Post/Check IP

musuku kucho yeha neevu ganta paguluddi neeku
Top of pagePrevious messageNext messageBottom of pageLink to this message

Pda
Desanike Pedda Bewarse
Username: Pda

Post Number: 8206
Registered: 06-2006
Posted From: 129.138.18.85

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

Posted on Friday, March 30, 2007 - 2:49 pm:Edit PostDelete PostView Post/Check IP

naakudesh andulo conpuse kavaneeki emee ledu.. nuvve conpuse setunnav
Learn from yesterday, live for today, hope for tomorrow
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Desanike Pedda Bewarse
Username: Nayakudu

Post Number: 6396
Registered: 05-2005
Posted From: 129.188.69.145

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

Posted on Friday, March 30, 2007 - 2:43 pm:Edit PostDelete PostView Post/Check IP

ippude naa pakka nodiki code lo INVALID_CURSOR exception vasthey defect find cheyyataniki help chesa... so evarikaina use avuthundemo nani ikkad apost chesa.. inka nunchi rojuko chitka ikkada PL/SQL lo
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Desanike Pedda Bewarse
Username: Nayakudu

Post Number: 6395
Registered: 05-2005
Posted From: 129.188.69.145

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

Posted on Friday, March 30, 2007 - 2:42 pm:Edit PostDelete PostView Post/Check IP

yemiti ala chusthunnavu gudlu pekutha GOSI baa
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse ke Bewarse!
Username: Gochi

Post Number: 38423
Registered: 07-2004
Posted From: 24.2.196.220

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

Posted on Friday, March 30, 2007 - 2:41 pm:Edit PostDelete PostView Post/Check IP

Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Desanike Pedda Bewarse
Username: Nayakudu

Post Number: 6394
Registered: 05-2005
Posted From: 129.188.69.145

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

Posted on Friday, March 30, 2007 - 2:41 pm:Edit PostDelete PostView Post/Check IP

for the starters,

%FOUND returns true if the last fetch to cursor returns a row, returns false if the last fetch to cursor doesn't return a row

%NOTFOUND - opposite to %FOUND
returns false if the last fetch to cursor returns a row, returns true if the last fetch to cursor doesn't return a row

you can use %NOTFOUND attribute along with EXIT WHEN clause if you want to exit out of a WHILE loop that iterates thru a cursor
Top of pagePrevious messageNext messageBottom of pageLink to this message

Nayakudu
Desanike Pedda Bewarse
Username: Nayakudu

Post Number: 6393
Registered: 05-2005
Posted From: 129.188.69.145

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

Posted on Friday, March 30, 2007 - 2:34 pm:Edit PostDelete PostView Post/Check IP

ippude okati refresh chesukunna cursors lo

%FOUND, %NOTFOUND

when try to access either of the 2 cursor attributes stated above, you will get INVALID_CURSOR exception incase cursor is not opened at the point in the program