10-28-2009
Until the package commits, you cannot see anything it put into a table, regardless of what your perl script may be doing.
If you need to see the changes, either change the pl/sql script to commit after every transaction, so your perl script can see it, or change the package itself to do the edits. It makes more sense, design-wise, to have the pl/sql package edit the changes - it should have gotten them correct to start with.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I have never programmed in Perl (insert laughter, mock, etc. here ____) - so I need a sort of "Programming in Perl" covering the basics.
I now have two Perl books, one is a 5 volume Unix resource kit, the other is "Mastering algorithms with Perl" - none of them explains how to produce "hello,... (11 Replies)
Discussion started by: AtleRamsli
11 Replies
2. Shell Programming and Scripting
Could someone suggest some good on-line PERL resources? tutorials and References?
Thanks.
Gregg (1 Reply)
Discussion started by: gdboling
1 Replies
3. Shell Programming and Scripting
i'm used a sql query in a unix script to get the information from table. but unable to extract the output which i need. Any help with logic will be greatly appreciated.
my sql query provide output some thing like this -
col1 col2 count
---- ---- ------
A B 10
c D 6
e... (8 Replies)
Discussion started by: pharos467
8 Replies
4. Shell Programming and Scripting
I have some alphbetical codes in that (1 Reply)
Discussion started by: kavithakuttyk
1 Replies
5. UNIX and Linux Applications
Hello,
Met a problem when I tried to insert rows to MySQL database from an old book that fits my learning level (MySQL and Perl for the Web, by Paul DuBois, 2001). First, under mysql console I created a database: webdb and the table: todo. Then I draft the perl-cgi script to have online page.... (0 Replies)
Discussion started by: yifangt
0 Replies
6. Shell Programming and Scripting
Hi All,
I have around 900 Select Sql's which I would like to run in an awk script and print the output of those sql's in an txt file.
Can you anyone pls let me know how do I do it and execute the awk script? Thanks. (4 Replies)
Discussion started by: adept
4 Replies
7. Shell Programming and Scripting
I have sql query in shell script.
select distinct account_no from adj order by account_no;
This query returns account number daily.Sometimes it may return 90 rows sometime it may return 1 row only and someday it may return 0 rows
I am storing the output of this query in sql_output.txt.
... (5 Replies)
Discussion started by: rafa_fed2
5 Replies
8. Shell Programming and Scripting
Hi all,
I have written a perl code and stored the data into Data structure using Data::Dumper module.
But not sure how to retreive the data from the Data::Dumper.
Eg.
Based on the key value( Here CRYPTO-6-IKMP_MODE_FAILURE I should be able to access the internal hash elements(keys) ... (1 Reply)
Discussion started by: scriptscript
1 Replies
9. Shell Programming and Scripting
Hello,
Currently, I am reading few queries from the below .sql file
--SOURCE TABLE NAME
--SOURCE QUERY
SEL COL1, COL2, COL3, COL4,
COL5, COL6, COL7 WHERE COL5 = '2015-11-04 16:24:00.000000' FROM SOURCE TABLE;
--TARGET TABLE NAME
--TARGET QUERY
SEL COLUMN1, COLUMN2, COLUMN3, COLUMN4,... (4 Replies)
Discussion started by: ronitreddy
4 Replies
10. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT CENTOS
dh_bugfiles
DH_BUGFILES(1) Debhelper DH_BUGFILES(1)
NAME
dh_bugfiles - install bug reporting customization files into package build directories
SYNOPSIS
dh_bugfiles [-A] [debhelperoptions]
DESCRIPTION
dh_bugfiles is a debhelper program that is responsible for installing bug reporting customization files (bug scripts and/or bug control
files and/or presubj files) into package build directories.
FILES
debian/package.bug-script
This is the script to be run by the bug reporting program for generating a bug report template. This file is installed as
usr/share/bug/package in the package build directory if no other types of bug reporting customization files are going to be installed
for the package in question. Otherwise, this file is installed as usr/share/bug/package/script. Finally, the installed script is given
execute permissions.
debian/package.bug-control
It is the bug control file containing some directions for the bug reporting tool. This file is installed as
usr/share/bug/package/control in the package build directory.
debian/package.bug-presubj
The contents of this file are displayed to the user by the bug reporting tool before allowing the user to write a bug report on the
package to the Debian Bug Tracking System. This file is installed as usr/share/bug/package/presubj in the package build directory.
OPTIONS
-A, --all
Install debian/bug-* files to ALL packages acted on when respective debian/package.bug-* files do not exist. Normally, debian/bug-*
will be installed to the first package only.
SEE ALSO
/usr/share/doc/reportbug/README.developers.gz
debhelper(1)
This program is a part of debhelper.
AUTHOR
Modestas Vainius <modestas@vainius.eu>
11.1.6ubuntu2 2018-05-10 DH_BUGFILES(1)