>
> --- thava prahash <thavaprahash@...> wrote:
><HR>
>Hi All,
>
>Would appreciate if anyone could share if conversion from Oracle with
>significant amount of stored procedures to Firebird is possible. There is
>some mention of support for store procedure in Borland website with
>regards to Interbase but i can't find any about stored procedure support
>in Firebird. All assistance greatly appreciated.

If you mean "are Oracle P/L and Firebird PSQL the same?" the answer is
emphatically No. Programming SQL is vendor-specific, i.e. there are no
standards. Even the ways different RDBMSs compile, store and access SPs
are completely idiosyncratic. PSQL has some nice features not found in
others, e.g. exception handling and database events.

So - the answer to your next question is: yes, you will have to study the
Firebird or InterBase documentation on stored procedure and trigger language.

NB. Please don't post to our lists in HTML. Plain text only please.

Helen