Sql command inside shell script runs without giving anything back as outout
Code:
#!/bin/sh
# This script returns the number of rows updated from a function
echo "The execution is starting ....."
sqlplus -silent $UP <<EOF
set serveroutput on
set echo off
set pagesize 0
VAR no_rows_updated NUMBER;
EXEC :no_rows_updated :=0;
DECLARE
CURSOR c_update is
SELECT * FROM BELK_BOOKS FOR UPDATE OF AUTHOR_NAME;
BEGIN
FOR REC IN c_update
LOOP
UPDATE Belk_Books
SET AUTHOR_NAME='ASFAKUL'
WHERE CURRENT OF c_update;
:no_rows_updated:=c_update%ROWCOUNT;
--no_rows_updated:=no_rows_updated+1;
END LOOP;
Commit;
--SELECT c_update%ROWCOUNT INTO no_rows_updated from Dual;
--no_rows_updated:=c_update%ROWCOUNT;
--DBMS_OUTPUT.PUT_LINE(no_rows_updated);
EXCEPTION
WHEN OTHERS THEN
:no_rows_updated:=SQLCODE;
ROLLBACK;
END;
/
exit :no_rows_updated ;
EOF
error_exit=$?
if [ $error_exit -ne 0 ]; then
echo "There was an error or 0 rows updated"
else
echo "The number of rows updated is : $error_exit"
fi
How do I create a K Shell which would silently (without user input) logon to Oracle and
run an SQL script?
Any help will be greatly appreciated.
Steve (1 Reply)
Hi,
In my shell script when I am using mv command using shell variables it is giving me error of syntax. Following is the shell script:
file_edifice="*.txt"
fquote="'"
fdquote=\"
for file in $file_edifice
do
file_name=$fquote$file$fquote
tofile_name=`date... (5 Replies)
Hi all,
I need a shell script which runs a sql script but I couldn't find how to finish it. This is the code that I have:
#! /usr/bin/ksh
export SHELL=/bin/ksh
export ORACLE_SID=database
export ORACLE_HOME=/opt/oracle/product/9.2.0.8
sqlplus user <<EOF @/path/path/path/scriptname.sql... (3 Replies)
Hi,
My script is running with no erros but not giving any output can anyonehelp.
#!/bin/ksh
. /home/application/bin/application.env
OUTFILE=Result.txt
PROD_PASSWORD=`${GET_PWD} -f ${PWD_FILE_PATH} -s ${PROD_SERVER} -u ${PROD_USER}`
echo "1)To get the book last loaded details "
read... (7 Replies)
HI,
I have a strange problem. A shell script that runs fine on solaris. when i ported to linux, it started hanging.
here is the core of the script
CFG_FILE=tab25.cfg
sort -t "!" -k 2 ${CFG_FILE} | egrep -v "^#|^$" | while IFS="!" read a b c
do
#echo "jobs output"
#jobs
#echo "jobs... (13 Replies)
Hi All,
Is there any way to monitor a command inside shell script ? I have a script inside which I have a tar command which zips around 200GB data.
tar zcvf $Bckp_Dir/$Box-BaseBackup-$Day.tar.gz * --exclude 'dbserver_logs/*' --exclude postmaster.pid --exclude 'pg_xlog/*'
I want to... (3 Replies)
Hi, I'm new to these forums, and I'm hoping that someone can solve this problem...
To make things short:
I have DD-wrt set up on a router.
I'm trying to run a script in CRON that fetches the daily password from my database using SSH.
CRON is set like so(in web interface):
* * * *... (4 Replies)
OS version : AIX 6.1
Shell : Korn
When you 'postfix' a command with ampersand (&) , it is supposed to run in the background and give you back the control.
I tested this with ping command (by default it pings every 1 second )
After I ran the below ping command with ampersand, I pressed... (3 Replies)
hii,,
I am trying to automate jira. during my scripting using bash script, in the terminal i got the terminal message like this:
"Configure which ports JIRA will use.
JIRA requires two TCP ports that are not being used by any other
applications on this machine. The HTTP port is where you... (1 Reply)
Hi,
i have a source file and have 3 columns and separated by "|" .i want to split this 3 columns in different variable.When i am executing this values indivisually giving correct result but when the same execute inside a for loop,it's giving issues.
Src file(jjj.txt)
-------... (8 Replies)
Discussion started by: raju2016
8 Replies
LEARN ABOUT PHP
dbx_fetch_row
DBX_FETCH_ROW(3) 1 DBX_FETCH_ROW(3)dbx_fetch_row - Fetches rows from a query-result that had the DBX_RESULT_UNBUFFEREDflag setSYNOPSIS
mixed dbx_fetch_row (object $result_identifier)
DESCRIPTION dbx_fetch_row(3) fetches rows from a result identifier that had the DBX_RESULT_UNBUFFERED flag set.
When the DBX_RESULT_UNBUFFERED is not set in the query, dbx_fetch_row(3) will fail as all rows have already been fetched into the results
data property.
As a side effect, the rows property of the query-result object is incremented for each successful call to dbx_fetch_row(3).
PARAMETERS
o $result_identifier
- A result set returned by dbx_query(3).
RETURN VALUES
Returns an object on success that contains the same information as any row would have in the dbx_query(3) result data property, including
columns accessible by index or fieldname when the flags for dbx_query(3) were set that way.
Upon failure, returns 0 (e.g. when no more rows are available).
EXAMPLES
Example #1
How to handle the returned value
<?php
$result = dbx_query($link, 'SELECT id, parentid, description FROM table', DBX_RESULT_UNBUFFERED);
echo "<table>
";
while ($row = dbx_fetch_row($result)) {
echo "<tr>
";
foreach ($row as $field) {
echo "<td>$field</td>";
}
echo "</tr>
";
}
echo "</table>
";
?>
SEE ALSO dbx_query(3).
PHP Documentation Group DBX_FETCH_ROW(3)