Oracle7 stored-procedures from VB
From: <bwitt_at_tdsc1.actd.saic.com>
Date: Thu, 28 Jul 1994 01:03:21 GMT
Message-ID: <1994Jul28.011329.951_at_ast.saic.com>
Date: Thu, 28 Jul 1994 01:03:21 GMT
Message-ID: <1994Jul28.011329.951_at_ast.saic.com>
Has anyone successfully called (exec'd) an Oracle7 stored-procedure from VB? I'm using Q+E's Oracle ODBC driver and when I execute 'Set Ds = db.CreateDynaset (sql, DB_PASSTHROUGH)' the following error message appears: 'ODBC - call failed.[Q+E Software][ODBC Oracle driver][ORACLE][ORA-00972: identifier is too long][#972]'. The stored-procedure name is 7 chars long and I'm passing 3 parameters. The total length of string sql, including the exec verb, is 38 chars.
We're using SQL*Net v2.0. Any responses greatly appreciated. Received on Thu Jul 28 1994 - 03:03:21 CEST