Here is My Problem, I have a complicated login porcess, there are two seperate databases involve in it. Firstly, I will search the userid in the local sql server 2005 database, if not found I will call an oracle package which is being develop by a third party(none comercial) and that package will verify the userid and password and return me user's present credentials (rolse, orgs, etc) as dataset. My question is how do a call that oracle package from asp.net application and how do a recieve a oracle dataset or cursor at the asp.net. Sorry if i wasnt clear. I really do need help on this, any help will be appreciated.

I will like to use ODP.net if at all possible.

 Thanks

 Kabir

The following link has a comprehensive discussion on how to create Oracle packages/procedures and call them.

http://msdn2.microsoft.com/en-us/library/ms971506.aspx

 Hi prasanth

  when i checked the link i m not getting the page.

message

The page cannot be found

Thank u

Baba
 

Sorry about that. I have fixed the link in my earlier post and it should be ok now. Please have a look now.