thanks olichap. I finally got it to work. I found some info at http://www.vbip.com/books/1861003927/chapter_3927_16.asp
I just have to change the connection string to the following.
cnOracle.ConnectionString = "Provider=OraOLEDB.Oracle;User ID=hcc;password=memo2114;Data...
olichap, was your reply/question directed towards me or WireHed. If it is, then yes my package/procedure all compile correctly.
The error occur when I ran the VB script. The error indicated something about wrong argument in procedure. ulwitch said that its not necessary to specify an out...
Hi olichap and ulwitch,
I've been reading your discussion about getting a recordset from Oracle store proc through VB. Instead of VB, I'm using VB script to get back the recordset. I've done eveything you guys said but when I ran script, I get an Oracle error saying that its wrong type of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.