I can't answer all your questions, but I first suggest you do a search here on my member ID in the Oracle and VFP Forums. Use key words like Oracle, Stored, Procedure, Package, Books.
>We have an app that currently is using SQL Server. We've been asked to support Oracle as well.
>
>I have some general questions, and a few specific ones:
>
>1) While much of our SQL Server syntax is ANSI-compliant, we also do a fair amount of CREATE TABLE #TempTable statements. Are temp tables created in Oracle in the same way?
What are the temp tables used for? To fetch records for easier processing in a SP? If so, this is usually done by defining and using a cursor in the SP.
>2) Are there any significant differences/challenges in a .NET environment where Oracle would be used instead of SQL Server?
I doubt it. A connection is a connection. The only differences would be in how SPs are created and called, plus any other differences between SQL Server and Oracle. However, I have minimal knowledge of SQL Server.
>3) We are thinking of developing a lengthy script to create all the stored procs and updated triggers for a SQL Server database. Is there a 'scripting language' that is compatible with both SQL Server and Oracle, so that you can have one long script/text file that could created triggers and stored procs for a database, for both SQL Server and Oracle?
I do not know. A search here might find something.
>4) Does SQL Pass-Through (SQLEXEC) work as cleanly with Oracle as it does with SQL Server?
IMO, yes.
>5) Last question is more a general one, if anyone has additional advice/web site references/etc for how to construct an app that can use either database.
Build your framework such that it only takes the switch of a parameter to indicate what database is being used so all your other methods know what syntax to use when issuing SQL queries. Develop a connection class to manage your connections.
Mark McCasland
Midlothian, TX USA