从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屋！