How to use ASP to operate Oracle Database

zhaozj2021-02-16  106

Oracle Object Server contains six objects 1.OraClient 2.OreSession 3.OraConnection 4.OraDatabase 5.OraDynaset 6.OraSQLstmt 7.OraField 8.OraParameter 9.OraParameterArray 1.Oraclient objects OraClient objects records all OraSession objects 2.OraSession OraSession objects Usually used in the application, manage ORADATABASE, ORACONNECTION, ORADYNASET objects. Set ORASESSION = CREATEOBJECT ("OracleInProcser.xoRasession) 3. Oraconnection object represents a connection to ORADATABASE objects, which automatically generates an ORACONNECTION object when you want to create an ORADATABASE object. 4. OraDatabase object ORADATABASE object represents a virtual login for the database server. Set ORADATABASE = ORASESSION.DBOPENDATABASE ("Database Alkname", "User Name / Password", 0) 5. ORADYNASET Object ORADYNASET object allows users to browse or update data returned by SQL SELECT. ORADYNASET must belong to the unique ORADATABASE object, so if you create an ORADYNASET object, you can use ORADATABASE's dbcreateDynaset or createDynaset, both results.

转载请注明原文地址:https://www.9cbs.com/read-11078.html

New Post(0)