Re: cursor definition

[Paul DuBois]

At 7:08 PM +0000 6/28/01, Yamuna Vallipuram wrote:
>Hi...
>
>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
>
>Yamuna


-- 
Paul DuBois, paul@stripped