Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: VB & Oracle Stored Proc Problem
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