Sponsored Content
Top Forums Shell Programming and Scripting How to Pass the Output Values from the PL/SQL Procedure to Shell Script? Post 302444288 by guruprasadpr on Wednesday 11th of August 2010 12:21:57 PM
Old 08-11-2010
Hi
Please provide us with what you have tried till now to help you better.

Guru.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how to pass values from oracle sql plus to unix shell script

how to pass values from oracle sql plus to unix shell script (2 Replies)
Discussion started by: trichyselva
2 Replies

2. Shell Programming and Scripting

need help on shell script(to pass the values)

only the arguments that are written to the file, my script is (sh /u01app/wkf.sh"$start_no","$name","$Condition","$file_name") like that when ever I run my script I need to write into a new file every time, like wise I have upto10 files with different names.bec my $start_no and $name will... (1 Reply)
Discussion started by: sai123
1 Replies

3. Shell Programming and Scripting

How to pass parameter from sqlplus(procedure completed) to your shell script

if then # mail -s "Import failed file does not exist" sanjay.jaiswal@xyz.com echo "FILE does not exist" exit 1 fi echo "FILE EXIST" size=-1 set $(du /export/home/oracle/nas/scott21.dmp.gz) while do echo "Inside the loop" size=$1 set $(du... (1 Reply)
Discussion started by: sanora600
1 Replies

4. Shell Programming and Scripting

How to pass pl/sql table values to shell script

Hello, i am using '#!/bin/bash', i want to make a loop in pl/sql, this loop takes values from a table according to some conditions, each time the loop choose 3 different variables. What i am not able to do is that during the loop i want my shell script to read this 3 variables and run a shell... (1 Reply)
Discussion started by: rosalinda
1 Replies

5. Shell Programming and Scripting

how to store the return values of stored procedure in unix shell script.

hi i am calling a oracle stored procedure(in the database) from unix shell scripting (a.sh). the called stored procedure returns some values through OUT variables i want to assign the return values of stored procedure in to unix shell script variable. can you provide me the code. ... (1 Reply)
Discussion started by: barani75
1 Replies

6. Shell Programming and Scripting

how to pass the values to unix shell from the oracle stored procedure.

Hi i am calling a stored procedure from unix shell like this call test_proc('0002','20100218'); the stored procedure was giving output like this dbms_output.put_line(' processed earlier'); i want to see the output in the unix shell where i called. Thanks barani (6 Replies)
Discussion started by: barani75
6 Replies

7. Shell Programming and Scripting

calling pl/sql procedure from shell and return values

How could I call an Oracle PL/SQL procedure from any shell (bash) and catch returning value from that procedure (out param) or get a returning value if it's a function. also, I got into trouble when I tried to send a number as a param #!/bin/bash -e username=$1 pwd=$2 baza=$3... (0 Replies)
Discussion started by: bongo
0 Replies

8. Shell Programming and Scripting

How to pass Oracle sql script as argument to UNIX shell script?

Hi all, $ echo $SHELL /bin/bash Requirement - How to pass oracle sql script as argument to unix shell script? $ ./output.sh users.sql Below are the shell scripts and the oracle sql file in the same folder. Shell Script $ cat output.sh #!/bin/bash .... (7 Replies)
Discussion started by: a1_win
7 Replies

9. Shell Programming and Scripting

Unable to pass value from .Shell script to .SQL file

Hi All, I am new to shell script. I am trying to pass value from .sh file to .sql file . But I am able to run the .sql file from .sh file with values in sql file. But I am unable to pass the values from .sh file. can some one please help to resolve this. here is my .sh file s1.sh ... (4 Replies)
Discussion started by: reddy298599
4 Replies

10. UNIX for Dummies Questions & Answers

Emailing results of a pl sql procedure from UNIX shell script

Hello All, I am writing the below unix script to email the result of a small pl sql procedure: #!/bin/bash ORACLE_HOME=/opt/oracle/orcts/product/9.2.0; export ORACLE_HOME SQLPLUS=$ORACLE_HOME/bin/sqlplus sqlplus -s user/pass@Db_instance<<EOF set echo off set feedback off set pages 0... (9 Replies)
Discussion started by: Bunty bedi
9 Replies
Padre::Autosave(3pm)					User Contributed Perl Documentation				      Padre::Autosave(3pm)

NAME
Padre::Autosave - auto-save and recovery mechanism for Padre SYNOPSIS
my $autosave = Padre:Autosave->new( db => 'path/to/database' ); $autosave->save_file( $path, $type, $data, $timestamp ) = @_; DESCRIPTION
The longer auto-save plan The following is just a plan that is currently shelved as some people on the Padre development list think this is not necessary and one should use a real version control for this anyway. So I leave it here for now, for future exploration. I'd like to provide auto-save with some history and recovery service. While I am writing this for Padre I'll make the code separate so others can use it. An SQLite database will be used for this but theoretically any database could be used. Event plain file system. Basically this will provide a versioned file system with metadata and automatic cleanup. Besides the content of the file we need to save some meta data: path to the file will be the unique identifier timestamp type of save (initial, auto-save, user initiated save, external) When opening a file for the first time it is saved in the database.(initial) Every N seconds files that are not currently in "saved" situation are auto-saved in the database making sure that they are only saved if they differ from the previous state. (auto-save) Evey time a file is saved it is also saved to the database. (user initiated save) Before reloading a file we auto-save it. (auto-save) Every time we notice that a file was changed on the disk if the user decides to overwrite it we also save the (external) changed file. Before auto-saving a file we make sure it has not changed since the last auto-save. In order to make sure the database does not get too big we setup a cleaning mechanism that is executed once in a while. There might be several options but for now: 1) Every entry older than N days will be deleted. Based on the database we'll be able to provide the user recovery in case of crash or accidental overwrite. When opening padre we should check if there are files in the database that the last save was not a user initiated save and offer recovery. When opening a file we should also check how is it related to the last save in the database. For buffers that were never saved and so have no file names we should have some internal identifier in Padre and use that for the auto-save till the first user initiated save. The same mechanism will be really useful when we start providing remote editing. Then a file is identified by its URI ( ftp://machine/path/to/file or scp://machine/path/to/file ) my @types = qw(initial, autosave, usersave, external); sub save_data { my ($path, $timestamp, $type, $data) = @_; } perl v5.14.2 2012-06-27 Padre::Autosave(3pm)
All times are GMT -4. The time now is 09:14 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy