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

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Execute an Oracle stored procedure from a shell scrip

Here is a snippet of my code: if then echo "\n Deleting all reports older than 24 hours. \n" >> $logfile ls -l $FileName >> $logfile ...

2. UNIX for Dummies Questions & Answers

execute store procedure

Hi, can someone point out the tutorial or syntax for how to execute store procedure through shell scripting . thanks.

3. Shell Programming and Scripting

Calling stored procedure from shell script

HI, I have a similar problem to thread 18264, only I couldn't get it to work. https://www.unix.com/showthread.php?t=18264 I have a stored procedure which is called by a shell script program. When I run the stored procedure alone or through the shell script, it works fine with output text...

4. Shell Programming and Scripting

How to execute an Oracle procedure using shell

Hi , i have created an .sh file that has the following code: #!/bin/ksh sqlplus -s p1istuat/p1istuat@CWS_IST6 @Procedure_Execute.sql & sqlplus -s p1istuat/p1istuat@CWS_IST6 << EOF exit EOF The mentioned Procedure_Execute.sql file inside has the following code: exec TEST; ...

5. Shell Programming and Scripting

How to execute the stored procedure from shell script

How to execute the stored procedure from shell script and is there any possibility to print the dbms output in a log file.

6. Shell Programming and Scripting

Shell Linux to connect to a database and execute store procedure

HI, i want to write a script (Linux) that: 1) connect to a database oracle 2) execute some store procedure. Can anybody help me, please? Thanks a lot Andrew

7. Shell Programming and Scripting

Execute stored procedure through script in sybase database and store the output in a .csv file

Hi, I have a sybase stored procedure which takes two input parameters (start_date and end_date) and when it get executed, it gives few records as an output. I want to write a unix script (ksh) which login to the sybase database, then execute this stored procedure (takes the input parameter as...

8. 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...

9. Shell Programming and Scripting

Execute a shell script from Oracle procedure

Hi Gurus, Want to execute a shell script from a oracle procedure and get the status of the same, any assistance in this regard will be appreciated. proc_data.sh is script name which I want to execute from oracle procedure It should work something like below procedure test begin...

10. UNIX for Beginners Questions & Answers

Shell script to execute Oracle procedure and trigerring email on success and failure

Here is the shell script which need to trigger a stored procedure and when the record count is 0 then it should capture in the log that 0 duplicate records are found and if it's more than 0 then log with no of records. Also if there is any sqlerror then it should write the same in the log file and...

LEARN ABOUT CENTOS

authen::sasl::perl::login

Authen::SASL::Perl::LOGIN(3)				User Contributed Perl Documentation			      Authen::SASL::Perl::LOGIN(3)

NAME

       Authen::SASL::Perl::LOGIN - Login Authentication class

SYNOPSIS

	 use Authen::SASL qw(Perl);

	 $sasl = Authen::SASL->new(
	   mechanism => 'LOGIN',
	   callback  => {
	     user => $user,
	     pass => $pass
	   },
	 );

DESCRIPTION

       This method implements the client and server part of the LOGIN SASL algorithm, as described in IETF Draft
       draft-murchison-sasl-login-XX.txt.

   CALLBACK
       The callbacks used are:

       Client

       user
	   The username to be used for authentication

       pass
	   The user's password to be used for authentication

       Server

       getsecret(username)
	   returns the password associated with "username"

       checkpass(username, password)
	   returns true and false depending on the validity of the credentials passed in arguments.

SEE ALSO

       Authen::SASL, Authen::SASL::Perl

AUTHORS

       Software written by Graham Barr <gbarr@pobox.com>, documentation written by Peter Marschall <peter@adpm.de>.  Server support by Yann
       Kerherve <yannk@cpan.org>

       Please report any bugs, or post any suggestions, to the perl-ldap mailing list <perl-ldap@perl.org>

COPYRIGHT

       Copyright (c) 2002-2004 Graham Barr.  All rights reserved. This program is free software; you can redistribute it and/or modify it under
       the same terms as Perl itself.

       Documentation Copyright (c) 2004 Peter Marschall.  All rights reserved.	This documentation is distributed, and may be redistributed, under
       the same terms as Perl itself.

       Server support Copyright (c) 2009 Yann Kerherve.  All rights reserved. This program is free software; you can redistribute it and/or modify
       it under the same terms as Perl itself.

POD ERRORS

       Hey! The above document had some coding errors, which are explained below:

       Around line 175:
	   Unknown directive: =over4

       Around line 177:
	   '=item' outside of any '=over'

perl v5.16.3							    2010-06-02					      Authen::SASL::Perl::LOGIN(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Execute an Oracle stored procedure from a shell scrip

Discussion started by: mh53j_fe

2. UNIX for Dummies Questions & Answers

execute store procedure

Discussion started by: epall

3. Shell Programming and Scripting

Calling stored procedure from shell script

Discussion started by: dorisw

4. Shell Programming and Scripting

How to execute an Oracle procedure using shell

Discussion started by: vins_san