WebNickson
Programmer
I always seem to have lots of problem calling my Oracle Stored Procedures using the ADO Command. There is always some error and it's so difficult to debug because of the ambiguous error msg!
I always read lots of talk that it is good to use stored procedures because it is fast and so on and so forth... but the difficulty of debugging and the amt of codes required to write makes it so difficult for development and maintenance! That's mine personal opinion.
I was wondering what's your voice out there on this issue. Perhaps this only happens with Oracle db and not MS SQL where it much more straightforward with the datatype matching and lots of plenty good samples to start off from.
I will be very grateful if someone could point me a good reference for calling Oracle SP in ASP and also some good samples to refer to.
rgds,
Nickson