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 -> VB & Oracle Stored Proc Problem

VB & Oracle Stored Proc Problem

From: David W. Brown <yngdaveb_at_visbas.microserve.net>
Date: 1997/03/27
Message-ID: <5hcm6q$4k9$3@news3.microserve.net>#1/1

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.

Any suggestions?

David W. Brown
yngdaveb_at_microserve.net

http://www.microserve.net/~yngdaveb                                              Hail to the Redskins!
Received on Thu Mar 27 1997 - 00:00:00 CST

Original text of this message

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