I'm trying to use the June 05 EntLib to call an Oracle 9i stored proc.  Do do
this I have to specify the package the sp is in.  If I put the package name
in front of the sp name in my vb (i.e. Dim spName As String =
"package.SPName" then it works fine.  However then my code is Oracle
specific, and if I need to switch to SQL Server I have to remove the package
names, rebuild, ...

If I leave the package name out (what I prefer) and use the Oracle Package
node of the Oracle connection string in the EntLib Configuration interface I
get an error that the sp is not defined.

Can anyone explain how to make the latter work?

Selecting, Inserting and Updating Relational Data (SQLServer/ADO.NET)
Updating - let me count the ways
Connect to Foxpro Data (*.DBF) in VB.Net
2nd layer of filtering?
Problem connecting to sql server