List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 29 2001 3:08am
Subject:Re: cursor definition
View as plain text  
At 7:08 PM +0000 6/28/01, Yamuna Vallipuram wrote:
>I am new to MySQL and trying to write some database queries.
>(Basically, I am developing a WEB application using Pearl script. 
>The data is stored in MySQL database. Pearl scripts access the 
>database via Pearl DBI)
>I could not find any info about cursor definitions in MySQL documentations.

That's likely because MySQL doesn't have cursors.

Can you just run a standard DBI fetch loop?

>How do I write the following Oracle code in MySQL.
>Cursor CurPerson is
>            Select Arstall_Godkj_Stkomp
>            From  Person
>            Where Fodselsdato  = inFDato   And
>                  Personnr     = inPNr;;
>  Begin
>     Open curPerson;
>     Fetch CurPerson into refGodkjent;
>     If curPerson%Found Then
>Thank you

Paul DuBois, paul@stripped
cursor definitionYamuna Vallipuram28 Jun
  • Re: cursor definitionPaul DuBois29 Jun