Sponsored Content
Top Forums Shell Programming and Scripting Query a oracle DB when fail put in in the error log Post 302491772 by dsw on Friday 28th of January 2011 08:59:27 AM
Old 01-28-2011
Hi,

I would've thought that sqlplus's return value will be set according to system events, not internal SQL parsing?

Is it entirely non-functional presently?
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

oracle process query !

This query is For HP-UX 11i server. I have certain oracle process that are running on my system as below :- rotmgr 3986 1 0 07:49:33 ? 0:00 oracleedjlive (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) rotmgr 26356 1 0 08:14:32 ? 0:00 oracleedjlive... (4 Replies)
Discussion started by: kpatel786
4 Replies

2. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies

3. Shell Programming and Scripting

How to put db2 query result into an array in shell script?

Hello, Can someone please advise me how to put the db2 query reult into an array? For example, the query reults are: string A string B string C Then how do I put them into array=string A array=string B ... (2 Replies)
Discussion started by: hanul
2 Replies

4. Programming

Oracle Database Query

How can i modify the below to search for the things i'm looking for during a certain time frame? select Node, NodeAlias, Summary, Tally, AlertKey, AlertGroup, Manager, Agent from mrtg_alerts where LastOccurrence > '5-Dec-2010' order by Manager desc; In this particular case, this query is... (3 Replies)
Discussion started by: SkySmart
3 Replies

5. Shell Programming and Scripting

Read value from user and use it in Oracle SQL query

Guys can anyone just tell me whether i can pass a value(from UNIX SCRIPT) as an ARGUMENT in Oracle Query? e.g. echo "enter value" read value insert into tablename where col=$value /*something like this*/ (1 Reply)
Discussion started by: subodh.thakar
1 Replies

6. Shell Programming and Scripting

PROBLEM WITH ORACLE QUERY IN UNIX SCRIPT

hi Guys, i have a problem with oracle query in my unix script.. I'm getting the following error while executing.. ./logtab.sh: sqlplus -s "pmutv/pmutv1" << EOFSQL^Jset head off^Jinsert into... (2 Replies)
Discussion started by: apple2685
2 Replies

7. Shell Programming and Scripting

perl- oracle sql query

Hi, I am new to perl.How to query oracle database with perl??? Thanks (1 Reply)
Discussion started by: tdev457
1 Replies

8. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ... (2 Replies)
Discussion started by: DevendraG
2 Replies

9. Programming

Oracle query with field filter

Dear community, I have to make a query from a database and apply the following filter: select filed1,field2,field3 from database where (field1 contains only alphanumeric chars and NOT only numbers) Let me explain better what I Need: 21test ==> OK test ==> OK test21 ==> OK te21st ==>... (6 Replies)
Discussion started by: Lord Spectre
6 Replies

10. IP Networking

Connection to DB from client server through jdbc:Oracle:Oci8 fail

We tried to use to connect to DB using jdbc:Oracle:Oci8:@<SERVICE-A>. Connection fail / refuse with one DB .But its working with other databases. But through toad, jdbc thin client were able to connect. But this has happen suddenly and were able to connect previously. How to navigate this... (0 Replies)
Discussion started by: udara
0 Replies
MAKE-JPKG(1)						      General Commands Manual						      MAKE-JPKG(1)

NAME
make-jpkg - builds Debian packages from Java binary distributions SYNOPSIS
make-jpkg [OPTION]... [FILE] DESCRIPTION
make-jpkg builds a Debian package from the given Java distribution FILE. Supported java binary distributions currently include: * Oracle (http://www.oracle.com/technetwork/java/javase/downloads) : - The J2SE Development Kit (JDK), version 6 (update >= 10), 7 - The J2SE Runtime Environment (JRE), version 6 (update >= 10), 7 - The J2SE API Javadoc, version 6 (update >= 10), 7 (Choose tar.gz archives or self-extracting archives, do _not_ choose the RPM!) The following options are recognized: --full-name NAME full name used in the maintainer field of the package --email EMAIL email address used in the maintainer field of the package --changes create a .changes file --revision add debian revision --help display help text and exit --version output version information and exit Download a supported Java RE or SDK or API tar.gz or self-extracting archive from http://www.oracle.com/technetwork/java/javase/downloads and execute make-jpkg file with the downloaded file. The program asks the user for additional information and builds a Debian binary pack- age in the current directory. The program requires about 200 MB free disk space in a temporary directory. The temporary directory defaults to /tmp but you can specify an alternate directory by setting the environment variable TMPDIR. EXAMPLE
To install Oracle(TM) 7 Standard Edition JDK, download a release - 64 bits version of update 2 from http://www.oracle.com/technet- work/java/javase/downloads/jdk-7u2-download-1377129.html in this example - and invoke make-jpkg: make-jpkg <path_to_download_directory>/jdk-7u2-linux-x64.tar.gz This generate a Debian package in the current directory, that can be installed using dpkg: dpkg -i oracle-j2sdk1.7_1.7.0+update2_amd64.deb When you're done, you can delete initial download as well as generated package: rm <path_to_download_directory>/jdk-7u2-linux-x64.tar.gz oracle-j2sdk1.7_1.7.0+update2_amd64.deb ENVIRONMENT
TMPDIR base directory used for temporary files (defaults to /tmp) J2SE_PACKAGE_FULL_NAME full name used in the maintainer field of the package; if none is supplied then the default of "Debian Java Maintainers" is used. J2SE_PACKAGE_EMAIL email address used in the maintainer field of the package; if none is supplied the default of "pkg-java-maintain- ers@lists.alioth.debian.org" is used. SEE ALSO
update-java-alternatives(1) AUTHOR
This manual page was written by Hubert Schmid <j2se-package@z42.de>. It is now maintained by the Debian Java Maintainers <pkg-java-maintainers@lists.alioth.debian.org>. January 22, 2012 MAKE-JPKG(1)
All times are GMT -4. The time now is 02:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy