Sponsored Content
Top Forums Shell Programming and Scripting Error while running Procedure in shell script Post 302977027 by RudiC on Monday 11th of July 2016 10:04:09 AM
Old 07-11-2016
Just guessing: opera is an SQL function, not a shell function. You need to declare it within sqlplus...
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

error in running shell script in cron

#!/bin/bash CLASSPATH=. #CLASSPATH=${CLASSPATH}:${INSTALL_PATH}home/squidlog/CopyFile.java CLASSPATH=${CLASSPATH}:${INSTALL_PATH}usr/java/latest/lib/*.jar javac CopyFile.java echo "CLASSPATH=$CLASSPATH" #home/wbiadmin/JRE1.4.2/j2re1.4.2_15/bin/java CopyFile /usr/bin/java... (3 Replies)
Discussion started by: sari
3 Replies

2. Shell Programming and Scripting

Error while running as shell script

Storage_Unit=`du -h /var/spool/cron/root|awk '{print $1}'|sed -e "s/^.*\(.\)$/\1/"` If then Size=`du -h /var/spool/cron/root|awk '{print $1}'|sed 's/.\{1\}$//'` for Size_rounded_number in $(printf %.0f $Size); do ROUNDED_Size=$Size_rounded_number done if #setting a threshold of say... (1 Reply)
Discussion started by: proactiveaditya
1 Replies

3. Shell Programming and Scripting

`(' unexpected error when running a shell script in AIX

Hi, We are moving from linux to AIX servers, and as a result testing our scripts on the new platform. When I run one of our scripts, I get the following error message: ./branchDataUpdate.sh: syntax error at line 21 : `(' unexpected Following is an extract from the script: ...... ........ (1 Reply)
Discussion started by: dawgfather80
1 Replies

4. Shell Programming and Scripting

error running shell script

how can i fix this error. + f_Delete resync-printers.ksh: test: argument expected lpadmin: Expected printer or class after '-x' option! resync-printers.ksh: test: argument expected + f_Create resync-printers.ksh: trying to execute a function (20 Replies)
Discussion started by: ggoliath
20 Replies

5. Shell Programming and Scripting

Executing Procedure from shell script..

Hello, I created a sql file to create a Procedure, and it was successfully created. I created a sql file to execute the procedure, and it did without any errors, but i dont see the data been updated. The Execute procedure.sql script is: BEGIN set serveroutput on size 1000000 execute... (5 Replies)
Discussion started by: msrahman
5 Replies

6. Shell Programming and Scripting

Run stored procedure from shell script

Hello all, I am trying to run stored procrdure from shell script which takes one argument. And also I want to verify in the script whether the script executed successfully. However the Stored procedure is not running from shell script. Manually if I run it update the data in the table. Can... (29 Replies)
Discussion started by: PriyaSri
29 Replies

7. Shell Programming and Scripting

Launcher Error: while running shell script

Hi Experts, I have a shell script which used to take oracle database backup, which is scheduled in a tidal scheduling tool. however it is throwing an error while triggering the job and getting below error in the log file. "Launcher Error: This is an internal function" shell script is... (1 Reply)
Discussion started by: UnniVKN
1 Replies

8. Shell Programming and Scripting

SP2-0642 error while executing procedure from shell script

hi all, i have a unix script where i am calling a database procedure from it. while executing the procedure i am getting an error: but when i tried to call the same procedure manually then it ran successfully, i goggled this issue and found timezone.dat file missing at... (0 Replies)
Discussion started by: lovelysethii
0 Replies

9. Solaris

Error during running sqlplus command from shell script in Solaris

I am using following code to connect to oracle database from solaris shell script. which will try thrice to connect the database ...at the 4rth atempt it will exir=t. count=0 while ; do sqlplus -s $usrname/$password@dbSID <<-EOF | tee $logfile WHENEVER OSERROR EXIT 9; WHENEVER SQLERROR... (4 Replies)
Discussion started by: millan
4 Replies

10. Shell Programming and Scripting

Why i can't execute the procedure in shell script?

i have the following code inside a shell script .prog in oracle server when i call the program DBMS_OUTPUT.PUT_LINE(x_return_status|| ln_rep_req_id); will return 0 , it is very strange , i try to submit the concurrent request in oracle , and it can successfully executed, what am i missing ? i... (1 Reply)
Discussion started by: feilhk
1 Replies
SQL::Statement::Term(3pm)				User Contributed Perl Documentation				 SQL::Statement::Term(3pm)

NAME
SQL::Statement::Term - base class for all terms SYNOPSIS
# create a term with an SQL::Statement object as owner my $term = SQL::Statement::Term->new( $owner ); # access the value of that term $term->value( $eval ); DESCRIPTION
SQL::Statement::Term is an abstract base class providing the interface for all terms. INHERITANCE
SQL::Statement::Term METHODS
new Instantiates new term and stores a weak reference to the owner. value Abstract method which will return the value of the term. Must be overridden by derived classes. DESTROY Destroys the term and undefines the weak reference to the owner. NAME
SQL::Statement::ConstantTerm - term for constant values SYNOPSIS
# create a term with an SQL::Statement object as owner my $term = SQL::Statement::ConstantTerm->new( $owner, 'foo' ); # access the value of that term - returns 'foo' $term->value( $eval ); DESCRIPTION
SQL::Statement::ConstantTerm implements a term which will always return the same constant value. INHERITANCE
SQL::Statement::ConstantTerm ISA SQL::Statement::Term METHODS
new Instantiates new term and stores the constant to deliver and a weak reference to the owner. value Returns the specified constant. NAME
SQL::Statement::ColumnValue - term for column values SYNOPSIS
# create a term with an SQL::Statement object as owner my $term = SQL::Statement::ColumnValue->new( $owner, 'id' ); # access the value of that term - returns the value of the column 'id' # of the currently active row in $eval $term->value( $eval ); DESCRIPTION
SQL::Statement::ColumnValue implements a term which will return the specified column of the active row. INHERITANCE
SQL::Statement::ColumnValue ISA SQL::Statement::Term METHODS
new Instantiates new term and stores the column name to deliver and a weak reference to the owner. value Returns the specified column value. AUTHOR AND COPYRIGHT
Copyright (c) 2009,2010 by Jens Rehsack: rehsackATcpan.org All rights reserved. You may distribute this module under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl README file. perl v5.10.1 2011-02-01 SQL::Statement::Term(3pm)
All times are GMT -4. The time now is 06:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy