MIcrosoft Visio 2002 Enterprise Architect and Oracle 9i


R

Raju Joseph

Hi All,

I am currently doing database modeling using Visio 2002 Enterprise Architect
(that came with Visual Studio .NET) against Oracle 9i database.

I am creating Raw DDL codes, which are actually oracle package definitions
(CREATE PACKAGE in oracle). The problem is, when I attempt to update the
database with the script, it fails. After looking at the DDL it generated,
it turns out that visio is adding a DROP PROCEDURE clause before the CREATE
OR REPLACE PACKAGE clause.

Does any one has any ideas? Also, is there any way I can configure visio to
proceed even if there are errors like this because, oracle will still create
packages even if there are errors.

Any one has any other ideas? Or is visio not smart enough to be used against
oracle?

Thanks,

Raju Joseph
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top