Hello,

> Is there a way to migrate oracle database including packages,
> trigger, store procedure etc to firebird or the other way around?

Firebird doesn't support "packages". It also doesn't support
"stored functions", so there's no way you can convert those.

To migrate an Oracle database (tables, constraints, indices),
take a look at the Schema Migrator tool in Database Workbench:
www.upscene.com

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com