Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: VB & Oracle Stored Proc Problem

Re: VB & Oracle Stored Proc Problem

From: Duc Nguyen <nguyen_at_reston.ans.net>
Date: 1997/03/28
Message-ID: <333C4A98.15FB@reston.ans.net>#1/1

David W. Brown wrote:
>
> My problem is as follows:
>
> Stored Procedure:
>
> CREATE OR REPLACE PROCEDURE sp_get_test (acct_id OUT NUMBER, acct_desc
> OUT CHAR)
> AS
> BEGIN
> SELECT ACCOUNT_ID, ACCOUNT_DESC INTO acct_id, acct_desc FROM TEST;
> END;
>
> Called in VB using:
>
> sql = "begin sp_get_test(:acct_id,:acct_desc); end;"
> Set rs =
> g_dana_db.OpenRecordSet(sql,dbOpenSqlSnapShot,dbSqlPassThrough)
>
> Produces the Error:
>
> [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-01008: not all variables
> bound.

You can't return values from a stored procedure using the odbc driver that you're using. Your best bet is to use Oracle Object for OLE. It will do everything you want and is faster, IMHO. There might be newer odbc driver that will allow you to return values from stored procedures using the above method.
-Duc

>
> Any suggestions?
>
> David W. Brown
> yngdaveb_at_microserve.net
> http://www.microserve.net/~yngdaveb Hail to the Redskins!
  Received on Fri Mar 28 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US