![]() |
|
|
|
|
|||||||
| Forums | Portal | Register | Forum Rules | FAQ | Contribute | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts here. |
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Connecting to Oracle Database | dreams5617 | Shell Programming and Scripting | 4 | 05-02-2008 09:37 AM |
| Connecting to Oracle from Ruby on Rails | iBot | Oracle Updates (RSS) | 0 | 04-06-2008 02:10 AM |
| Having A Problem Connecting to Oracle Using Cron | goodmis | UNIX for Dummies Questions & Answers | 1 | 03-20-2007 01:12 PM |
| Connecting to Oracle from Shell..What Am I doing Wrong | dzyr4tt | Shell Programming and Scripting | 1 | 12-20-2006 10:05 PM |
| Connecting to a Oracle Db using SunOS | darmat0712 | UNIX for Dummies Questions & Answers | 2 | 03-03-2005 10:17 AM |
|
|
Submit Tools | LinkBack | Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
connecting to oracle thro informatica
Hi
I have a shell script which is running fine in unix. But if i call the shell script thro informatica workflow post session command task it is not giving me the sum(amount) to a output text file The sql_configh.sh file has uid@db/pwd script_path="/path" cd $script_path connstr=`grep "uid@db" $script_path/sql_config.sh` touch $script_path/sum_cr_amt.txt chmod 777 $script_path/sum_cr_amt.txt sqlplus -s > $script_path/sum_cr_amt.txt <<eof1 $connstr select round(sum (entered_cr),2) entered_cr from table_name where trunc(date_created)='04-jan-2008'; eof1 x=$? if [ x -ne 0 ] then exit 1 fi exit 0 I need your gr8 help Thanks Babu |
| Forum Sponsor | ||
|
|
|
#2
|
|||
|
|||
|
oracle_home
What errors do you get? Have you checked the logs? Probably sqlplus path is not defined and also, make sure that the ORACLE_HOME path is defined.
Define this in your script. Code:
export ORACLE_HOME=/path/to/oracle/home $ORACLE_HOME/bin/sqlplus ..... #rest of the stuff |
|||
| Google The UNIX and Linux Forums |