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, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php