Library tutorials & articles

Oracle8 and Oracle8i

By Wrox Press, published on 14 Jul 2001
Wrox Press
Page 1 of 13
  1. Introduction
  2. History of Oracle
  3. Client Components
  4. Configuring Net8
  5. Connecting to an Oracle database
  6. OLE DB Provider & ODBC
  7. Oracle Objects for OLE
  8. Overview of PL/SQL
  9. A sample ASP Application (1)
  10. A sample ASP Application (2)
  11. Stored Procedures
  12. Reference Cursors
  13. Summary

Introduction

Wouldn't life be a lot easier if everyone used the same operating system, the same Internet browser software and the same relational database? Unfortunately things aren't that simple, so we need to be as flexible as possible. This book introduces all the main databases and data sources that you, as an ASP developer, may come across. Here, we will cover one of the most important relational databases – Oracle .

In this chapter we will cover the basics of configuring a web server to connect to a remote Oracle8 or Oracle8i database, although many of the techniques apply equally well to previous versions of Oracle 7.x. We'll show you how to use the common ODBC Drivers and OLE DB Providers in conjunction with ActiveX Data Objects (ADO) to manipulate data stored within an Oracle database from within an ASP application.

We'll build upon each area by creating a collection of ASP scripts that will use the sample scott database schema showing how to retrieve and update data in a flexible and more importantly, scalable manner. We will finally cover the (unfortunately), advanced concept of retrieving recordsets from an Oracle stored procedure. Don't worry though, it's relatively easy to use scalar INPUT and OUTPUT parameters to return individual parameters from an Oracle stored procedure – which we'll also be covering in this chapter.

All of the SQL and ASP code for this sample application can be downloaded from the Wrox web site at http://www.wrox.com.

Related tags

asp, oracle, visual basic

Comments

  1. Phyllis Jarvis
    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

  2. Chee Kok Keong
    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

  3. Tran Cong An
    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.

  4. Gon zo
    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

  5. goughi
    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

  6. dafnaben
    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

  7. Developer Fusion Bot
    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).

AddThis

Related articles

Ask a question

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 ...

Languages

Web Development

Frameworks & Architecture

Other major sections