Problem with Calling sql file from shell script | Unix Linux Forums | Shell Programming and Scripting

  Go Back    


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

Problem with Calling sql file from shell script

Shell Programming and Scripting


Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 05-03-2007
sskc sskc is offline
Registered User
 
Join Date: May 2007
Last Activity: 3 May 2007, 5:21 PM EDT
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Problem with Calling sql file from shell script

I have created abc.sh file which will set the environment variables (UNIX env variables as well as ORACLE required variables like ORACLE_SID,ORACLE_HOME etc) and then calls a function file which checks for starts some logs and then it will try to execute the .sql file. The .sh, function file are as follows

--ABC.SH
#!bin/ksh

. /rcs/ct/src/bin/initialize_ct_func # This is calling the initializing func file

sql_run_ct_func_test /rcs/ct/scripts/test.sql #Calling the function file

--FUNCTION FILE

function sql_run_ct_func_test
{ v_function_name=sql_run_ct_func_test;
start_ct_func "$@"

if [ ! -a $1 ]
then
echo "!!! FAILED !!!" $1 "failed, exit status: 2" >> $v_shell_log
exit 2
fi

$SQLCMD << EOHD
set term off
set pages 0
set feedback off
set heading off
--set echo off
set pause off
set serverout on
whenever sqlerror exit rollback
spool $v_function_log
@$1
exit sql.sqlcode
EOHD


if [[ $2 != [Nn] ]] ; then oracle_error_func ; fi

v_function_name=sql_run_ct_func_test; end_ct_func
}


Now the problem is that the function file is being called and then exiting immediately without doing any thing. I tried checking whether Oracle env variables are set properly by adding "sqlplus uid/pwd" to the Environment variables setting file, which is working fine. But some how from function I am unable to execute the .sql file.

Request you to suggest some ideas.
Sponsored Links
    #2  
Old 05-03-2007
sskc sskc is offline
Registered User
 
Join Date: May 2007
Last Activity: 3 May 2007, 5:21 PM EDT
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Solved

I didnt give a function call inside the function file. Just called the function file so it entered and exited. Anyways thanks all
Quote:
Originally Posted by sskc
I have created abc.sh file which will set the environment variables (UNIX env variables as well as ORACLE required variables like ORACLE_SID,ORACLE_HOME etc) and then calls a function file which checks for starts some logs and then it will try to execute the .sql file. The .sh, function file are as follows

--ABC.SH
#!bin/ksh

. /rcs/ct/src/bin/initialize_ct_func # This is calling the initializing func file

sql_run_ct_func_test /rcs/ct/scripts/test.sql #Calling the function file

--FUNCTION FILE

function sql_run_ct_func_test
{ v_function_name=sql_run_ct_func_test;
start_ct_func "$@"

if [ ! -a $1 ]
then
echo "!!! FAILED !!!" $1 "failed, exit status: 2" >> $v_shell_log
exit 2
fi

$SQLCMD << EOHD
set term off
set pages 0
set feedback off
set heading off
--set echo off
set pause off
set serverout on
whenever sqlerror exit rollback
spool $v_function_log
@$1
exit sql.sqlcode
EOHD


if [[ $2 != [Nn] ]] ; then oracle_error_func ; fi

v_function_name=sql_run_ct_func_test; end_ct_func
}


Now the problem is that the function file is being called and then exiting immediately without doing any thing. I tried checking whether Oracle env variables are set properly by adding "sqlplus uid/pwd" to the Environment variables setting file, which is working fine. But some how from function I am unable to execute the .sql file.

Request you to suggest some ideas.
Sponsored Links
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
calling a sql file in my shell script dazdseg Shell Programming and Scripting 16 05-25-2010 10:33 AM
Calling sql file from shell script chintapalli001 UNIX for Advanced & Expert Users 1 11-24-2008 11:39 AM
calling a cgi file from shell script???? elavv Shell Programming and Scripting 1 08-07-2008 03:32 AM
calling sql file from shell script dummy_needhelp Shell Programming and Scripting 6 09-30-2007 10:55 PM
shell script calling problem dhananjaysk Shell Programming and Scripting 2 03-30-2006 09:48 AM



All times are GMT -4. The time now is 03:13 PM.