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

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/