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