Unix/Linux Go Back    


Shell Programming and Scripting Unix shell scripting - KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and shell scripts and shell scripting languages here.

Problem with Calling sql file from shell script

Shell Programming and Scripting


Closed    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 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 Unix and Linux 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 Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux 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:00 AM.