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;;
> Open curPerson;
> Fetch CurPerson into refGodkjent;
> If curPerson%Found Then
Paul DuBois, paul@stripped
|• cursor definition||Yamuna Vallipuram||28 Jun|
| • Re: cursor definition||Paul DuBois||29 Jun|