Exporting Stored Procedures from oracle to interbase

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 25 Jul 2002 14:28:40 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7026AE517@lnewton.leeds.lfs.co.uk>

Sameer,

you will have to rewrite your Oracle stored procs to get them to run under Interbase.
Interbase *can* have functions like INSTR etc, but these are normally supplied in a UDF lib (or DLL).

Have you checked out the latest Firebird release - this comes with many bugs fixed, a whole load of functions built in - and a large UDF lib supplied as standard.

Check out http://firebird.sourceforge.net/index.php

You can also download the entire set of manuals for Interbase 6.0 here - it's about 10 MB compressed :

http://firebird.sourceforge.net/index.php?op=doc&id=userdoc

But they are available as individual manuals too - from the same site.

Have fun.

Regards,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: sameer_at_infonox.com (Sameer) [mailto:sameer_at_infonox.com] Posted At: Thursday, July 25, 2002 9:55 AM Posted To: server
Conversation: Exporting Stored Procedures from oracle to interbase Subject: Exporting Stored Procedures from oracle to interbase

Can anyone please help me.
I need to export my stored porcedures from oracle to Interbase. I have a little knowledge of Interbase. I want to know one more thing.. Interbase doesnot have any in-built functions like substr, instr etc...? Received on Thu Jul 25 2002 - 08:28:40 CDT