Database Independency [message #38694] |
Mon, 06 May 2002 21:42 |
Raj
Messages: 411 Registered: November 1998
|
Senior Member |
|
|
hai,
We have Written Some Stored Procedures and Functions
for our Project in Oracle
ie max we hav 25 packages (with max 100 fns & 100 sp's)
Now We r planning in Generalizing the Prjt
to make it Work in any D/b
so Can any one throw Some light on this
what all to be done..
|
|
|
|
Re: Database Independency [message #38738 is a reply to message #38694] |
Thu, 09 May 2002 11:27 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
Oracle extensions to ANSI SQL include statements like decode, connect by and sequence number generators etc. Additionally PL/SQL language is proprietary to Oracle. You are probably best off by doing the SQL in a middle tier and connecting to whatever your DB is using something like ODBC. Of course you can't use sequences, decodes etc. The cost of testing all new code in all environments may make you rethink your requirements.
|
|
|