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

10 More Discussions You Might Find Interesting

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

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

3. 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 $...

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

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

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

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

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

9. UNIX for Dummies Questions & Answers

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

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

LEARN ABOUT PHP

oci_server_version

OCI_SERVER_VERSION(3)													     OCI_SERVER_VERSION(3)

oci_server_version - Returns the Oracle Database version

SYNOPSIS

       string oci_server_version (resource  $connection)

DESCRIPTION

	Returns a string with the Oracle Database version and available options

PARAMETERS

	      o $connection
		-

RETURN VALUES

	Returns the version information as a string or FALSE on error.

EXAMPLES

       Example #1

	      oci_server_version(3) example

	      <?php

	      $conn = oci_connect("hr", "hrpwd", "localhost/XE");
	      echo "Server Version: " . oci_server_version($conn);

	      // Displays:
	      // Server Version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
	      // With the Partitioning, OLAP, Data Mining and Real Application Testing option

	      oci_close($conn);

	      ?>

NOTES

       Note

	       In  PHP	versions  before 5.0.0 you must use ociserverversion(3) instead. This old name still can be used. However it is deprecated
	      and not recommended.

SEE ALSO

       oci_client_version(3).

PHP Documentation Group 												     OCI_SERVER_VERSION(3)

Shell Programming and Scripting