PLSQL Post: 302522969

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Receiving Value from plsql package.

Hi, I am working on a shell script that fires a plsql package. I would like the package to return a value to the shell script and then the shell script to return it to the javascript. Is it possible for the shell script to accept the return status from the plsql package and then pass it back...

2. IP Networking

Sending mails using plsql program

I am trying to send an email to personal id using plsql program. I have written a code in plsql using UTL_TCP package where opens the connections and then senda a mail. But when i execute the program mails are not being sent. I typed "mail" command on the unix box and got the below result...

3. Shell Programming and Scripting

To get value from Oracle Anonymous PLSQL block

Hi All, i need you help while accessing the value from anonymous PL/SQL block. Initially our requirement was to get the value from SQL statement. I was doing like... But now i need to use dbms_application_info.set_module in it. So i have planned to use anonymous block instead of SQL...

4. Programming

Executing shell script from PLSQL

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

5. Shell Programming and Scripting

Pass a value from Unix to PLSQL

Hi all, I need to pass a value from Unix to plsql block so that i can use the variable to in where caluse to get the desired output. I tried useing $variable_name, but it doesn't work. Any kind of help is appreciated. Thanks in advance.

6. Shell Programming and Scripting

Script to give plsql procedure output

##Execute the EDW_MEM_KEY_UPDATE procedure ext_sta=`sqlplus -s ${Connstr} <<eof set heading off; set pagesize 0; set feedback off; set serveroutput on; execute EDW_MEM_KEY_UPDATE ; quit; here` vara="ORA-" var=`echo $ext_sta | grep -c $vara ` Hi All, above is a part of my unix...

7. Solaris

Please help me how to administrate Oracle/plsql server

I previously worked for the L1 support on DNS/Apache servers in solaris10...... Now our team lead wants me to work on Oracle/plsql server for our new client.... I've to work without training... How can we know that Oracle/plsql server running in our machine ?? How to Administrate...

8. Shell Programming and Scripting

Connecting+Firing plsql to Oracle DB in one go

Hi, I am using the below command to connect to a remote Oracle DB from my unix shell script. sqlplus -s user1/password1@remotedbhost:1252/demo @/tmp/PROC_MS.prc But I get the below error. 1. Can you confirm if my code is correct ? 2. Can you help me overcome the error ?

9. Shell Programming and Scripting

Checking plsql flag status in UNIX

Hi,I have a stored procedure to verify no of months since current fiscal.I want a shell script to exit with returtn code when the verification fails,I have shell script below but this doesnt work sqlplus / << EOF WHENEVER SQLERROR exit 1 WHENEVER OSERROR exit 2 DECLARE v_time_period...

LEARN ABOUT DEBIAN

slags2.f

slags2.f(3)							      LAPACK							       slags2.f(3)

NAME

       slags2.f -

SYNOPSIS

   Functions/Subroutines
       subroutine slags2 (UPPER, A1, A2, A3, B1, B2, B3, CSU, SNU, CSV, SNV, CSQ, SNQ)
	   SLAGS2

Function/Subroutine Documentation
   subroutine slags2 (logicalUPPER, realA1, realA2, realA3, realB1, realB2, realB3, realCSU, realSNU, realCSV, realSNV, realCSQ, realSNQ)
       SLAGS2

       Purpose:

	    SLAGS2 computes 2-by-2 orthogonal matrices U, V and Q, such
	    that if ( UPPER ) then

		      U**T *A*Q = U**T *( A1 A2 )*Q = ( x  0  )
					( 0  A3 )     ( x  x  )
	    and
		      V**T*B*Q = V**T *( B1 B2 )*Q = ( x  0  )
				       ( 0  B3 )     ( x  x  )

	    or if ( .NOT.UPPER ) then

		      U**T *A*Q = U**T *( A1 0	)*Q = ( x  x  )
					( A2 A3 )     ( 0  x  )
	    and
		      V**T*B*Q = V**T*( B1 0  )*Q = ( x  x  )
				      ( B2 B3 )     ( 0  x  )

	    The rows of the transformed A and B are parallel, where

	      U = (  CSU  SNU ), V = (	CSV SNV ), Q = (  CSQ	SNQ )
		  ( -SNU  CSU )      ( -SNV CSV )      ( -SNQ	CSQ )

	    Z**T denotes the transpose of Z.

       Parameters:
	   UPPER

		     UPPER is LOGICAL
		     = .TRUE.: the input matrices A and B are upper triangular.
		     = .FALSE.: the input matrices A and B are lower triangular.

	   A1

		     A1 is REAL

	   A2

		     A2 is REAL

	   A3

		     A3 is REAL
		     On entry, A1, A2 and A3 are elements of the input 2-by-2
		     upper (lower) triangular matrix A.

	   B1

		     B1 is REAL

	   B2

		     B2 is REAL

	   B3

		     B3 is REAL
		     On entry, B1, B2 and B3 are elements of the input 2-by-2
		     upper (lower) triangular matrix B.

	   CSU

		     CSU is REAL

	   SNU

		     SNU is REAL
		     The desired orthogonal matrix U.

	   CSV

		     CSV is REAL

	   SNV

		     SNV is REAL
		     The desired orthogonal matrix V.

	   CSQ

		     CSQ is REAL

	   SNQ

		     SNQ is REAL
		     The desired orthogonal matrix Q.

       Author:
	   Univ. of Tennessee

	   Univ. of California Berkeley

	   Univ. of Colorado Denver

	   NAG Ltd.

       Date:
	   November 2011

       Definition at line 152 of file slags2.f.

Author
       Generated automatically by Doxygen for LAPACK from the source code.

Version 3.4.1							  Sun May 26 2013						       slags2.f(3)