0 Replies Latest reply on Jul 29, 2006 4:06 AM by 107732

    SqlDataSource to call oracle stored procedure which is in a package

    107732
      I tried to use SqlDataSource to call oracle stored procedure which is in a package. But when I opened SqlDataSource wizard, I don't see any procedures in that package. But in the Server Explorer and under my connection, I saw many folds, like Table, Viw, StoredProcedure, Package .... Under package fold I saw my package and inside package I saw all my stored procedures.

      I am wondering why I don't see the package in SqlDataSource configure data source wizard when I chose to specify a custom SQL statement or stored procedure.

      Any help is greatly appreciated.