VisualStudio 2005 and Oracle Packages?

[tryston02]

Hey guys, according to the needs of the customer we mush use Oracle as our DB, however we our using Visual Studio 2005 to develop in.

Our DBA has grouped and locked every store proc into Oracle packages (something SQL Server doesn't have).

How would we call or access those packages. Using the SqlDataSource control I see the property SelectCommandType but the only choices it gives you are "text" and "Store Procedure". Would we still choose Stored Procedure even though we are using packages (groups of related store procedures). How do we accomplish this?

Thanks guys,

Chris

[tryston02]

Nevermind. Got it.

For those interested, you need to install ODP.NET from Oracle.

And call the package/procedure like so:
commandType is StoredProcedure

myPackageName.myProcedureName