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.

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
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


---------------------------------------------------------------------
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

Reply via email to