08-22-2009
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I've a script that fetches various values from the database as below:
#! /bin/ksh
$conn="user/pwd@service_name"
`sqlplus -s << $conn EOF1
@xyz.sql
@pqr.sql
@abc.sql
EOF1`
The output of the script should generate txt files containing the results from queries which are further... (6 Replies)
Discussion started by: manthasirisha
6 Replies
2. UNIX for Dummies Questions & Answers
Hi, I need help again. When I run this shell script, it only runs the unld_date.sql piece and exits. How can I structure this to run all the way to the end? When I don't have the unld_date.sql piece in here, everything runs fine from the date compare piece all the way to the end. Thanks in... (5 Replies)
Discussion started by: siog
5 Replies
3. Programming
Hi All,
I am supposed to present the documentation for the PLSQL code (PACKAGES, PROCEDURE, FUNCTIONS) of my application. There are sufficient comments in my code. Has anyone written any Shell Script Utility which can parse the PLSQL code and generate some kind of document ( preferrably HTML not... (1 Reply)
Discussion started by: gauravsachan
1 Replies
4. Shell Programming and Scripting
Hi All,
I am supposed to present the documentation for the PLSQL code (PACKAGES, PROCEDURE, FUNCTIONS) of my application. There are sufficient comments in my code. Has anyone written any Shell Script Utility which can parse the PLSQL code and generate some kind of document ( preferrably HTML not... (2 Replies)
Discussion started by: gauravsachan
2 Replies
5. Shell Programming and Scripting
Hi,
I have this problem of merging 2 shell scripts and run it one after the other. For eg: script A runs to give OutputA. This OutputA should become the input of script B which will run to give OuputB. Now this has to happen automatically i.e, script A and script B should run consecutively one... (1 Reply)
Discussion started by: Vindhyaauri
1 Replies
6. Programming
Hi All,
I have a requirement to mv a file in unix from plsql procedure.
for that i have created a java host procedure, a host_command, given all grants as per ORACLE-BASE - Oracle8i Shell Commands From PL/SQL
but i am getting an error ""Process err :/bin/sh: mv Not Found""
kindly let me... (1 Reply)
Discussion started by: aryan_styles
1 Replies
7. Shell Programming and Scripting
Hi,
I have been assigned a job which requires me to send mails from unix(Mailx) upon on certain actions triggered in the database.
On insert/update of a certain field into one of the database tables the shell script present in Unix box responsible to send mail though mailx needs to be triggered... (7 Replies)
Discussion started by: hemant.bs11
7 Replies
8. Shell Programming and Scripting
I have a plsql procedure inside a package which is having one IN parameter .I want to call that procedure through a shell script and that IN parameter is a column of a table in the database. So my requirement is that i need to loop all the entries of that IN parameter from the table through shell... (4 Replies)
Discussion started by: rspnf
4 Replies
9. Shell Programming and Scripting
Hi all,
I have a PLSQL script which has a IN list where it takes some ids as input. For example
SELECT * FROM EMPLOYEE WHERE EMPLOYEE_ID IN (comma separated list )
I want to run this quest inside a shell script but I would like to prepare the IN list dynamically where the employee ids... (1 Reply)
Discussion started by: LoneRanger
1 Replies
10. Shell Programming and Scripting
I am running plsql using printf on a shell, but i am getting some strange error, can someone point what exactly am i missing,
$ echo $SHELL
/bin/bash
$ printf "
> SET serveroutput ON trimspool on feed off echo off
> declare
> p_val number;
> d_val varchar2(10);
> begin
> SELECT... (1 Reply)
Discussion started by: kamauv234
1 Replies
LEARN ABOUT DEBIAN
catalyst::model::dbi
Catalyst::Model::DBI(3pm) User Contributed Perl Documentation Catalyst::Model::DBI(3pm)
NAME
Catalyst::Model::DBI - DBI Model Class
SYNOPSIS
# use the helper
create model DBI DBI dsn username password
# lib/MyApp/Model/DBI.pm
package MyApp::Model::DBI;
use base 'Catalyst::Model::DBI';
__PACKAGE__->config(
dsn => 'dbi:Pg:dbname=myapp',
password => '',
username => 'postgres',
options => { AutoCommit => 1 },
);
1;
my $dbh = $c->model('DBI')->dbh;
#do something with $dbh ...
DESCRIPTION
This is the "DBI" model class.
METHODS
new Initializes DBI connection
$self->dbh
Returns the current database handle.
$self->stay_connected
Returns a connected database handle.
$self->connected
Returns true if the database handle is active and pingable.
$self->connect
Connects to the database and returns the handle.
$self->disconnect
Executes rollback if AutoCommit is active, disconnects and unsets the database handle.
SEE ALSO
Catalyst, DBI
AUTHOR
Alex Pavlovic, "alex.pavlovic@taskforce-1.com"
COPYRIGHT
Copyright (c) 2005 - 2009 the Catalyst::Model::DBI "AUTHOR" as listed above.
LICENSE
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2010-01-28 Catalyst::Model::DBI(3pm)