Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Stored procedures, ADO and VB 6.0 ....again ....HELP !!
I don't know what datatypes are returned by the procedures you are trying to
use, but I'm pretty sure that ADO can't return an Oracle recordset. Your best
bet is to use Oracle Objects For OLE (also known as OO4O). Check on your
Oracle CD - it's probably on there already. It's an OLE component that
functions as a more feature-rich database driver than ADO. It might be a good
fit for you, if you can get it to do any data binding that you'd need.
In article <74me6o$eah_at_info.telenor.no>,
"Jørgen Haukland" <jorgen.hauikland_at_fou.telenor.no> wrote:
> Hello !
>
> I've now spent 3 days trying to get VB 6.0 to fetch the result of a stored
> procedure without very much success. I should say. So now I'm back to basics
> and discovered the 'PERSONNEL.GET_EMPLOYEES' packaged procedure in the
> demobase that comes with Oracle, which would be a good starting point for
> what I am trying to accomplish in my VB app.
>
> BUT: I have trouble calling this d... thing from SQL*Plus - which I thought
> should be fairly easy. I'm running Oracle 8.0.4 on an NT 4.0 box.
>
> When I try f.ex:
> SQL> execute personnel.get_employees (20, 15, 5)
>
> I get this:
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00306: wrong number or types of arguments in call to 'GET_EMPLOYEES'
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> The procedure has 2 IN parameters and one IN OUT parameter. What am I doing
> wrong ?
>
> Has anybody good advice to get those employees in a VB TextBox via ADO ??
>
> Thanks !!
>
> Joergen Haukland
> NORWAY
>
>
--
-Jon.
--
Jon Atkinson * Senior Developer * Virtual Frontiers
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Dec 10 1998 - 13:31:59 CST