Re: ODBC Stored Procedure Problem.

leighj_at_merck.com wrote:
: I have a store procedure that I am trying start from VB 4.0 16bit. I
: can run SQL w/o a problem but I cannot get Execute to run my stored
: procedures. I get an error saying the ODBC Call failed. Any ideas?

I'm having a similar problem. Some of our procedures are in a package. When we try to call a procedure in the package we get a ODBC syntax error.

The syntax to call a stored procedure is:

        {call proc1(arg1, ...)}

but for a procedure in a package, the syntax should be:

        {call pkg1.proc1(arg1, ...)}

This second example works with the InterSolv ODBC drivers but this does not work with the latest Oracle 7 ODBC drivers which are availible from Oracle's web site. The following does work:

        BEGIN pkg1.proc1(arg1,...); END;

This works with InterSolv as well. For more info checkout the following Oracle Web page:

        http://www.oracle.com/support/products/odbc/95/html/doc.html

Look for the kink "Using the Oracle ODBC Drivers with Third Party Products - whitepaper". This is a .PDF file. So the Acrobat reader is needed.

Hope this helps. If you have more questions, please, let me know.

Later,
Steven
http://www.blkbox.com/~swhatley/

                      _|_  |  _|_   "I am the way and the truth and
Steven Whatley         | --|-- |    the life.  No one comes to the
swhatley_at_blkbox.com    |   |   |    Father except through me."
Houston, Texas             |            -- Jesus Christ (John 14:6 NIV)
                           |