![]() If you are not going to use that result set for anything else (ie: to generate another query to execute) then you do not need to declare a cursor. ![]() ![]() The cursor is simple the recordset results. Oracle creates an implicit cursor for every select query (I think that is the same for any database system). ![]() This will discuss what a ref cursor is and how to implement them and get data back. The results must come back to the calling program in something called a reference cursor (ref cursor). Getting a result set back from an Oracle SP is not as simple as it is in SQL Server. Now is where things start being specific to our Oracle database. CreateParameter(, adNumeric, adParamOutput) CreateParameter(, adVarChar, adParamOutput, 50) This is the same things we do for any Visual Basic database application. Properties(“Data Source”) = “DatabaseName”Īfter we setup the connection all we do next is setup an ADO Command object that will be used with our oracle database. We set the provider to be our Oracle provider and setup our connection string and password. We can simply use an ADO Connection object. To access an Oracle database it is very similar to how you access any other database. This VB6 tutorial will walk us through exactly how to do this. Because of this, we must know how to interface with an Oracle database from within our VB6 application. Oracle databases have been around for years, and although they are not as popular as their Microsoft counterpart, many business rely on Oracle backends for all their needs.
0 Comments
Leave a Reply. |