Need to pass Oracle SQL output to Linux and back... Help! Post: 302922843

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to pass a oracle variable back to the shell script

Hi, I am calling an oracle function that returns a number (either 0 or 2), how do I pass that pass to the wrapping shell script as I would like to do other things based on the value returned by the oracle function. Your help will be appreciated. -------------------------- sqlplus / <<...

2. UNIX for Dummies Questions & Answers

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

3. Filesystems, Disks and Memory

in Oracle Enterprise Linux not able to redirect pvscan output

hi, In Oracle Enterprise Linux I'm not able to redirect output of commands pvscan and vgscan into a file. File is coming blank Please suggest something Thanx.

4. Linux

In Oracle Enterprise Linux, not able redirect pvscan output

Hi, I'm not able to redirect output of ovscan and vgscan commands to a file in Oracle Enterprise Linux. Please suggest something. Thanks Mayank

5. Shell Programming and Scripting

How to Pass the Output Values from the PL/SQL Procedure to Shell Script?

hi, Could anyone tell me how to pass the output values of the PL/SQL procedure to Shell script and how to store that values in a shell script variable... Thanks in advance...

6. UNIX for Dummies Questions & Answers

Pass value back to unix variable

i had this unix korn shell code that connects to oracle database and execute the oracle procedure. i need to add a variable that indicates the oracle procedure failed. basically the variable is to check if the oracle procedure failed it will assign 1 and when the variable is equal to 1 it will not...

7. Shell Programming and Scripting

Pass perl array to SQL oracle

Hello, Could someone please suggest if there is a way to pass an perl array(pass @v_array) to SQL as in below eg : #!/usr/bin/perl @v_array = (1,2,4,5,6,8); $db_userid = 'ni71/ni711'; $bufTPO = qx{ sqlplus -s << EOF $db_userid set verify off set feedback off set...

8. UNIX for Dummies Questions & Answers

Removing unnecessary eol ($) character from Oracle sql query output

Hi All, I am fetching oracle query result in shell variable. As columns numbers are more the output wraps in unix terminal .i.e one complete record in db gets store in multiple lines. with each line ends with $ character. I want to remove these unnecessary $ character but to keep required $...

9. Programming

pass value from Oracle sql to Korn shell

Hi All , I am trying to pass a value from sqlplus to korn shell . There is a table tab1 in Oracle that has a column userdate. I need to pass the userdate to the korn shell . This is what I am doing . VALUE=`sqlplus -silent username/password << END set pagesize 0 feedback off verify off...

10. 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 ....

LEARN ABOUT MINIX

pbmtoascii

pbmtoascii(1)                                                 General Commands Manual                                                pbmtoascii(1)

NAME

       pbmtoascii - convert a portable bitmap into ASCII graphics

SYNOPSIS

       pbmtoascii [-1x2|-2x4] [pbmfile]

DESCRIPTION

       Reads a portable bitmap as input.  Produces a somewhat crude ASCII graphic as output.

       Note that there is no asciitopbm tool - this transformation is one-way.

OPTIONS

       The -1x2 and -2x4 flags give you two alternate ways for the bits to get mapped to characters.  With 1x2, the default, each character repre-
       sents a group of 1 bit across by 2 bits down.  With -2x4, each character represents 2 bits across by 4 bits down.  With the  1x2  mode  you
       can  see the individual bits, so it's useful for previewing small bitmaps on a non-graphics terminal.  The 2x4 mode lets you display larger
       bitmaps on a standard 80-column display, but it obscures bit-level details.  2x4 mode is also good  for  displaying  graymaps  -  "pnmscale
       -width 158 | pgmnorm | pgmtopbm -thresh" should give good results.

SEE ALSO

       pbm(5)

AUTHOR

       Copyright (C) 1988, 1992 by Jef Poskanzer.

                                                                   20 March 1992                                                     pbmtoascii(1)