从unix脚本调用存储过程 [英] calling a stored procedure from a unix script
问题描述
我没有UNIX和oracle的任何经验。
但是我写了一个简短的编写unix脚本的作业这将调用存储过程。这个脚本必须在每两分钟后运行这个程序。
在实际开始编写脚本之前我有几个问题:
1。我是否必须在同一台服务器上安装unix和oracle。
2.我需要在unix中使用哪些库,如果有的话
我试过sqlplus 用户/密码@ databasename 我只在这个论坛得到了但是它说 ksh:sqlplus:找不到
请帮我出。在此先感谢。
Hi,
I don''t have any experiance of UNIX and oracle.
but i have got a short assignment for writing a unix script that will call a stored procedure. this script has to run this procedure after every two mintes.
I have a few questions before actually start writing the script:
1. Do i have to have unix and oracle on same server.
2. what libraries i need to in unix, if any
I tried sqlplus user/password@databasename which i got in this forum only but it''s saying ksh: sqlplus: not found
please help me out. Thanks in advance.
推荐答案
请查找详细信息此处 。
我没有UNIX和oracle的任何经验。
但是我有一个简短的作业,用于编写一个调用存储过程的unix脚本。这个脚本必须在每两分钟后运行这个程序。
在实际开始编写脚本之前我有几个问题:
1。我是否必须在同一台服务器上安装unix和oracle。
2.我需要在unix中使用哪些库,如果有的话
我试过sqlplus 用户/密码@ databasename 我只在这个论坛得到了但是它说 ksh:sqlplus:找不到
请帮我出。提前致谢。
Hi,
I don''t have any experiance of UNIX and oracle.
but i have got a short assignment for writing a unix script that will call a stored procedure. this script has to run this procedure after every two mintes.
I have a few questions before actually start writing the script:
1. Do i have to have unix and oracle on same server.
2. what libraries i need to in unix, if any
I tried sqlplus user/password@databasename which i got in this forum only but it''s saying ksh: sqlplus: not found
please help me out. Thanks in advance.
在调用sqlplus命令之前设置环境。
可以使用设置环境。 newfin"命令。
例如:
Set the environment before calling sqlplus command.
Environment can be set using ". newfin" command.
Eg:
。 newfin<实例名称>
. newfin <instance name>
这篇关于从unix脚本调用存储过程的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!