Subject Re: [firebird-support] Firebird support of PL/SQL like language
Author Theo Bebekis
Niko

> I would like to ask if there is a language similar to Oracle's PL/SQL in Firebird allowing someone
> to write packages and procedures with cursors , variables , loops, if statements etc.

Go to
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_download_documentation

and get the
Interbase 6.0 Beta Documentation.

Interbase/Firebird trigger and procedure language is described by the
Interbase 6.0 Language Reference document.

There is no CURSOR concept in IB/FB though, but you
could use the FOR SELECT....DO construction instead

Regards
Theo

PS. Packages?
-----------------------------------------------
Theo Bebekis
Thessaloniki, Greece
-----------------------------------------------
Greek_Delphi_Prog
a Delphi programming list in greek language at
http://groups.yahoo.com/group/Greek_Delphi_Prog
-----------------------------------------------