PL/SQL with Non-Oracle Databases?

[Capo]

I know PL/SQL is an oracle tool, but can you use it to query non-oracle databases (such as sybase)? I know it has the ODBC importer, but I'm referencing connecting to the DB and working in the SQL window as you do with oracle databases.

Anyone know?

Thanks!

 

[KenHigg]

It's the industry standard SQL statements that part of pl sql which are cross platform compatable.


ken

 

[Capo]

It's the industry standard SQL statements that part of pl sql which are cross platform compatable.


ken

I am still a bit new to PLSQL, so any help would be appreciated. I have all of my ODBC connections setup under my windows data sources... I am seeing my oracle databases in that list but I am not seeing my sybase ones. How do I get those to showup so that I can query them via standard SQL?

I can see all of my ODBC connections fine in Access, but im not seeing the sybase ones in PLSQL.

Thanks!

 

[KenHigg]

I'm not 100% sure but seems you'll need to run the ODBC admin on your machine and add them as data sources. Maybe you could google 'sybase odbc' and see what you get...

 

[Capo]

I have the sybase DBs as valid data sources in windows and they work fine with Access... I suppose I need to see if I can find a way to get PLSQL to recognize these.