Re: Oracle Data Control in VB 6

Thanks Sybrand. Yes Oracle help is fairly minimal compared to many products (meaning explanatory help not just 1 sentence error msg lists), but that's neither here nor there. I'd previously searched sites such as the one you gave me for ORA-01008 but what they come up with (error msg definition) isn't exactly full of info. But, thanks, I'm adding that site to my list of references.

What I was wondering was how I might fix the problem. The 3 variables that have to be in the SP call (in order for me not to get a SQL syntax error) are simply output variables from the SP. There are no input parameters.

So, I think I understand that the 3 output parameters from the SP aren't 'defined' in VB, so there might be probs. But, is there a way for me to tell the ADO control about the definition of those 3 parameters it will be passed from Oracle? Do I have to do this rather through a Data Environment Command where I can visually define the variables & map data types?

Again, just trying to see if it's possible to do without hand coding in a class or form... Thanks for the info & I look forward to any other info you can pass my way.

Brian Received on Fri Feb 08 2002 - 13:30:31 CST