Re: ORACLE Configuration

dmoyer_at_gpu.com wrote:

>>- Any experience in accessing Oracle on UNIX from a client running Smalltalk
>> either on OS/2 Warp or Win95 ? Which SW is required ?
 

>Sorry, can't help you here.

using ODBC is a possible solution, you still need SQL*NET for this. (on OS/2 Warp also SQL*NET VDM)

>>- Is there a way to access Oracle DBs without SQL which should be considrable
>> faster than SQL ?
 

>Why wouldn't you use SQL? SQL is fast on a properly tuned database.

yes, if you write a RPC demon on Server and a RPC client, but I think this is not worth to be done, because SQL*NET is not so expensive like developing the RPC demon and client.

>>- Is it possible to store forms,reports,graphics in the oracle db ?
 

>Yes, they all can be stored in the DB. We have not done it. Initial testing with
>Forms 4.0 showed that it was slower than file access.

Yes, works fine, but depending on the speed on your Database it is at least 2..3 times slower. A good solution is to develop with forms,... stored in the database. If the development is finished, the runforms could be created with generator (maybe for multibe OS) for each OS.

>> Can I then run it out of the oracle db or from a server ?
 

>The runtime software does not reside in the database. The executables can be
>run from either the DB or file system.
 

>>- Doese oracle provide a version control for forms, reports, graphics, more ?
>>
 

>I think the Developer/2000 package has some form of version control in its
>procedure builder tool.

No, not real, but the support for PCSV (I´m not sure if this is right spelled) is included within the Developer/2000 Received on Tue Oct 17 1995 - 00:00:00 CET