Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007
    Posts
    1

    Unanswered: Ingres procedures

    hi

    i am not able to use cursor in ingres procedures it shows me the compilation error ,currently i am using ingres II.
    kindly reactify my problem.

    regards
    ashish

  2. #2
    Join Date
    Feb 2007
    Location
    Courbevoie, France
    Posts
    10
    Hello,

    You can not use cursors in a database procedure. Please read the "Create Procedure" help on the Ingres web site (http://docs.ingres.com/sqlref/CreateProcedure).

    In a DB Proc you can use only one of the following statements :
    * COMMIT
    * DELETE
    * ENDLOP
    * EXECUTE PROCEDURE
    * FOR
    * IF
    * INSERT
    * MESSAGE
    * RAISE DBEVENT
    * RAISE ERROR
    * REGISTER DBEVENT
    * REMOVE DBEVENT
    * RETURN
    * RETURN ROW
    * ROLLBACK
    * SELECT
    * UPDATE
    * WHILE
    * Assignment statements

    Hope this help,
    Jean-Pierre Zuate
    jean-pierre.zuate@lafageconseil.fr
    http://lafageconseil.fr/
    Jean-Pierre ZUATE
    La Fage Conseil - Ingres & IT Service
    http://lafageconseil.fr/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •