Re: Help with Oracle COM Components

Hi Roy,

I am not an expert but what I think your IT people are referring to is that your 'front end' for the database was developed using COM components such as drop down lists etc. These are tools that are used in developing the User Interface for the application. Since these tools are part of the windows operating system if you port your application over to a Unix platform you will have to redesign you user interfaces (screens etc) so that they dont rely on these components. They are not available in Unix.

This is an issue for Oracle Applicaton Developers. To keep their applications cross platform compatible they have to develop using tools that available from within Oracle itself and not rely on products and tools that are operating system dependant.

Hope this answers your question.

Tony

Roy wrote:
>
> Hi,
>
> I'm looking for some information on the usage of Oracle COM
> Components. Let me give you a little background on what we want to do,
> and what help I need.
>
> We have a number of what I consider "small" Oracle databases, each
> running on their own NT server (at most 2 databases on 1 server). To
> reduce costs, we are looking to redeploy these databases onto 1 or 2
> large Unix servers.
>
> One of these is a system used to pay commissions to our sales staff.
> When we asked the development staff the impact of moving just the
> backend from the NT server to the Unix server, the reply was:
>
> - Certain modules in application use Oracle COM Components. The same
> could not be done with Oracle on UNIX . Module need to be re-written
> using Microsoft based applications.
>
> I don't know enough about Oracle COM Components to know if this is the
> case or not. Are the COM components fully integrated with the
> database, in such a way that moving the database to another machine
> would require development changes? Or should moving the database not
> affect the application, assuming we update the tnsnames.ora file and
> network connectivity is present?
>
> Appreciate any information on these COM components and their
> functionality.
>
> Thanks
> - Roy
Received on Thu May 09 2002 - 01:28:19 CDT