Setting an Oracle parameter for the return value and calling ExecuteNonQuery did the trick! Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.
Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related Output; objCmd. The first thing to do is create four CRUD procedure to the emp table. Listing 11 shows how to create the package header. And finally, let's see the application code in Listing As you can see, to fill the data table, we need to define the CRUD create, read, update, delete operations through the OracleCommand and associate it to the DataAdapter.
I fill the data table, and print out a message with the number of employees so far, and then add a new row representing one employee entity. StoredProcedure; objSelectCmd. Output; objAdapter. StoredProcedure; objInsertCmd. Number, 4, "empno" ; objInsertCmd. VarChar, 10, "ename" ; objInsertCmd. VarChar, 9, "job" ; objInsertCmd. Number, 4, "mgr" ; objInsertCmd. DateTime,12, "hiredate" ; objInsertCmd. Number, 7, "sal" ; objInsertCmd. Number, 7, "comm" ; objInsertCmd.
Number, 7, "deptno" ; objAdapter. StoredProcedure; objUpdateCmd. Number, 4, "empno" ; objUpdateCmd. VarChar, 10, "ename" ; objUpdateCmd. VarChar, 9, "job" ; objUpdateCmd. Number, 4, "mgr" ; objUpdateCmd. DateTime, 10, "hiredate" ; objUpdateCmd. Number, 7, "sal" ; objUpdateCmd. Number, 7, "comm" ; objUpdateCmd. StoredProcedure; objDeleteCmd. As you can see, to fill the data table, we need to define the CRUD create, read, update, delete operations through the OracleCommand and associate it to the DataAdapter.
I fill the data table, and print out a message with the number of employees so far, and then add a new row representing one employee entity. StoredProcedure; objSelectCmd. Output; objAdapter. StoredProcedure; objInsertCmd. Number, 4, "empno" ; objInsertCmd. VarChar, 10, "ename" ; objInsertCmd. VarChar, 9, "job" ; objInsertCmd. Number, 4, "mgr" ; objInsertCmd. DateTime,12, "hiredate" ; objInsertCmd. Number, 7, "sal" ; objInsertCmd. Number, 7, "comm" ; objInsertCmd.
Number, 7, "deptno" ; objAdapter. StoredProcedure; objUpdateCmd. Number, 4, "empno" ; objUpdateCmd. VarChar, 10, "ename" ; objUpdateCmd. VarChar, 9, "job" ; objUpdateCmd.
Number, 4, "mgr" ; objUpdateCmd. DateTime, 10, "hiredate" ; objUpdateCmd. Number, 7, "sal" ; objUpdateCmd. Number, 7, "comm" ; objUpdateCmd. StoredProcedure; objDeleteCmd. Remove From My Forums. Answered by:. Archived Forums. Visual Basic. Not for VB6 questions. Sign in to vote. I am using VB. Net and 10g. Thursday, December 12, PM.
0コメント