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
 

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

Similar Threads

Forvard engineering Visio 2003-2002 1
Can Visio generate a Valid Oracle DDL Statement ? 4
Visio Enterprise availability (2002 and 2003) 1
visio 2003 enterprise architect looks like visio 2002 16
Limit on Foreign Key relationships in Enterprise Architect? 0
No forward engineering in Visio for Enterprise Architects 0
Visio and Underlying Data Model 0
Visio Enterprise Architect: Enhanced for Visual Studio 2005 ??? 1

Top