VB,ODBC & Stored Procedures
From: Michele Bolos <MBOLOS_at_INCASE.COM>
Date: 1995/07/25
Message-ID: <3v3a5a$s4m_at_alterdial.UU.NET>#1/1
Date: 1995/07/25
Message-ID: <3v3a5a$s4m_at_alterdial.UU.NET>#1/1
Hello!
Does anyone know the syntax to create a snapshot or dynaset in Visual Basic to access a stored procedure on an Oracle 7 database? I am getting the error "Invalid SQL Statement" when I try the following:
Set MySnap = MyDB.CreateSnapshot("Create_Jane_doe", 64)
Create_Jane_doe is my stored procedure ....
I have looked in books such as "ODBC 2" and Oracle books for documentation on how to properly execute it and I cannot find it. If anyone can help, I would appreciate it.
Thanks in Advance!
~ Michele Received on Tue Jul 25 1995 - 00:00:00 CEST