<% 'OK Establishs a stored procedure, the user must have the permissions of CREATE Procedure grant create procedure to yangbc2;' The following is an example of performing a stored procedure.
set conn = server.createobject ( "adodb.connection") 'OK constr = "Driver = {Microsoft ODBC for Oracle}; Server = yang11; Uid = yangbc2; Pwd = yang9812;"' OK 'constr = "Provider = OraOLEDB. ORACLE.1; Password = CHANGE_ON_INSTALL; PERSIST Security Info = true; user ID = sys; data source = yang11 "Conn (constr) set = server.createObject (" adoDb.recordset ")
'Ok' sql = "Create Table yangbc2.a10 (Name varcha2 (10) Not null, id varcha2 (10) Not null)" SQL = "yangbc2.test1" ropen sql, conn, 3, 3 'performs stored procedures The same effect as the next sentence, you can 'Conn.execute ("yangbc2.test1")' to perform stored procedures
'rs.close' has this error SET RS = Nothing conn.close set conn = Nothing response.write "OK, Successful, YANGBC"%>
