Shell Programming and Scripting

#!/bin/ksh

# want to run as a different process
/path_to_called_script/called_script.ksh 10 20

#!/bin/ksh

sqlplus -s ${connection} <<EOF

sample_procedure($1,$2);
exit;
EOF

$ cat caller.ksh

#!/bin/ksh

# want to run as a different process
./called_script.ksh 10 20

$ cat called_script.ksh
#!/bin/ksh

cat -s ${connection} <<EOF

sample_procedure($1,$2);
exit;
EOF

$ ./caller.ksh

sample_procedure(10,20);
exit;

$

${MMHOME}/external/scripts/belk_nil_prc_thread.ksh 10 20

function EXEC_BELK_NEW_ITEM_LOC_PRICING
{
   echo "set feedback off
      set heading off
	  set echo off
      set serveroutput on size 1000000

      VARIABLE GV_return_code    NUMBER;
      VARIABLE GV_script_error   CHAR(255);
	  VARIABLE GV_process_flag   CHAR(10);

      EXEC :GV_return_code := 0;
      EXEC :GV_script_error := NULL;
	  EXEC :GV_process_flag := 'TRUE';

      WHENEVER SQLERROR EXIT ${FATAL}
      
      BEGIN
         BELK_NEW_ITEM_LOC_PRICING($1,$2,:GV_script_error,:GV_process_flag);
		 
	  
      EXCEPTION
         
         WHEN OTHERS THEN
		     ROLLBACK;
             :GV_return_code := ${FATAL};
      END;
        
	 
	   print :GV_process_flag;
       print :GV_script_error;
	   exit  :GV_return_code;
       /" | sqlplus -s ${connectStr} >> ${errTemp}
	   
    if [ $? -eq ${FATAL}} ]; then
	
      echo "${pgmName}:FAILED at EXEC_BELK_NEW_ITEM_LOC_PRICING() with error ${errTemp} !" >>${ERRORFILE}
      
      LOG_MESSAGE "${pgmName}:EXEC_BELK_NEW_ITEM_LOC_PRICING() Failed !"
    
      return ${FATAL}
	fi
	
		
}

#!/bin/ksh

priceA=$1
priceB=$2

...

function EXEC_BELK_NEW_ITEM_LOC_PRICING
{
   echo "
    ....

    BEGIN
    BELK_NEW_ITEM_LOC_PRICING($priceA,$priceB,:GV_script_error,:GV_process_flag);
    ... 
    " | sqlplus -s ${connectStr} >> ${errTemp}
...
}

. /path/to/script
. ./script

source /path/to/script
source ./script