Library tutorials & articles

Oracle8 and Oracle8i

Summary

That just about brings us to the end of this guide to connecting to an Oracle database from an ASP application. We covered quite lot of ground here:

  • Installation and configuration of the Oracle8 client software, Net8
  • Using the Microsoft OLE DB Provider for Oracle
  • Using the Microsoft OLE DB Provider for ODBC
  • Using Oracle Objects for OLE (OO4O)
  • PL/SQL fundamentals
  • Creating a sample ASP application based on the scott account
  • Showing that it is possible to retrieve an ADO Recordset from an Oracle stored procedure, using both PL/SQL tables and reference cursors
  • Before we finish this chapter, take look at the chart below comparing  each of the common methods of data access for Oracle. I added an additional 7000 records to the emp table and then used each of the methods to retrieve these records and display them using an ASP script. Each method was executed three times and after each test I rebooted the server machine so that there would be very little chance of data being cached by either Oracle or the web server (for this test the web server also doubled as the Oracle database server to cut the time taken to shutdown and restart).


    In these tests, MSDAORA  was used with a standard SQL SELECT statement, as was the ODBC Driver for Oracle and OO4O, and finally I used the ODBC Driver for Oracle in conjunction with PL/SQL tables, and Oracle's Oracle Provider for OLE DB  with a reference cursors as just described. The Y-axis shows the amount of time taken to complete each test in seconds. I also monitored the CPU and memory usage and they were all very similar for each test.

    You can see that there is not that much difference between each method. When choosing which method to use, the underlying factor will always be good database design and coding practices.

    Don't forget that you can download all of the SQL and ASP scripts for this chapter from the Wrox web site at http://www.wrox.com.

    Comments

    1. 23 Sep 2009 at 11:36

      hi i am awaneesh from new delhi. actually i have a problem in sql group by function. i have one table with 120 columns or variable. i want group by all. so for this work i have to select all the columns in select stmt and again write all columns in group by stmt. So plese tell me the way, how can i select all the cols & how can group by all cols in short method. like: select * from emp group by (120 columns) but i don't to write all the cols in select stmt and again all the cols in group by stmt. please tell me the way. & send the solution back to my e-mail id- awan_tiwari2005@yahoo.co.in i will be really grateful to you.

      With best wishes, Awaneesh Tiwari

    2. 21 May 2009 at 09:05

      fuck all programmers!

    3. 16 Mar 2004 at 10:45

      How can I create a master detail web form using ASP, ADO, vbscript, and HTML?jarvis@anteon.com">email me

    4. 02 Dec 2003 at 04:10
      Hi all,

      I've been trying to use the OLE DB connection from ASP to Oracle. Used the code from the examples. Working fine but it did not release the session connection and when the sessions reach the maximum defined, it will fail to work. Pls Help. Thank you.

      KK
    5. 19 Jun 2003 at 05:15
      Hi,
       I using .NET to access Oracle DB  (with OLEDB Provider for Oracle) but I have a trouble that I couldn't use Unicode datatype (such as: NCHAR, NVARCHAR2).
       
       Anyone knows how to do this or any Provider that allows us access Oracle DB with Unicode datatype?

       Thanks for you kindness.
       TCAN.
    6. 24 Feb 2003 at 12:17

      im trying to get this to work:


      when the form loads, a csv file is opened and whose contents are displayed in the Current list view control. if the user selects an item from the Current listview control and presses the "delete" key (i've been using the Keypress event), a message box will pop up asking them to confirm their decision. If they say yes, the entire row is cleared and that row's information is passed to another listview control (the Archives listview control, which is saved onto its own file)


      the main things i need to know are the ASCII code for the delete key (127 doesn't work...), and how to delete an entire row in a listview control (and the other records below it should be moved up as a result.) If you could tell me how to then pass it onto the second listview control as well, that would be greatly appreciated.


      thanks in advance

    7. 24 Feb 2003 at 10:39
      Hi,
           i am currently do a project on oracle and microsoft. The question is compare and contrast the latest database offerings from Oracle and Microsoft under the following headings: History and evolution of the products, Target Market, Functionality, Customers, Future Directions, and any other areas. Any inforamton would be appreciated
    8. 22 Dec 2002 at 06:06


      Hi ,

      I'm using resultset in oracle and vbscript as it was mentioned here as follow:

      create a package that return a ref cursor,execute the package in vbscript and get the resultset into the
      recordset .
      Sometime it works and othertime I get that error in the line when I call the execute to the procedure:

      OraOLEDB error '80004005'

      Unspecified error .

      I used the example you gave in page :http://www.developerfusion.com/show/671/12/

      Please help me
    9. 01 Jan 1999 at 00:00

      This thread is for discussions of Oracle8 and Oracle8i.

    Leave a comment

    Sign in or Join us (it's free).

    Wrox Press

    Related discussion

    Related podcasts

    • Java Posse #213 - Newscast for Oct 23rd 2008

      Newscast for Oct 23rd 2008 Fully formatted shownotes can always be found at http://javaposse.com The Android project has been released as open source, beating the rumored launch date for the source code by several months http://source.android.com/ And, Gizmodo and ZDNet both offer in-depth ...

    Want to stay in touch with what's going on? Follow us on twitter!