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 (2 Replies)
Discussion started by: trichyselva
2 Replies
2. Shell Programming and Scripting
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
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
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
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
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
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
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
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
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
LEARN ABOUT DEBIAN
padre::autosave
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)