03-02-2010
Barani,
i was thinking to declare the parameter that you want as output as OUT parameter and calling the function. But yeah... once you log into SQL, taking the parameter from SQL session to UNIX session is not possible.
OK... Leave that.
Lets try the other one.
Direct the output of the SQL session, to a file throught DBMS_OUTPUT.PUT_LINE statements.
and then read the variable from that file.
What do you think abt this one ?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi, I need help again. When I run this shell script, it only runs the unld_date.sql piece and exits. How can I structure this to run all the way to the end? When I don't have the unld_date.sql piece in here, everything runs fine from the date compare piece all the way to the end. Thanks in... (5 Replies)
Discussion started by: siog
5 Replies
2. UNIX for Advanced & Expert Users
Could anyone please help me. I have a function in plsql that returns a number. But i am listing some records through that function using DBMS_OUTPUT.PUT_LINE. I want to catch those records by executing this function through a unix script. The following shows what i did
echo "Connected from... (2 Replies)
Discussion started by: cobroraj
2 Replies
3. Shell Programming and Scripting
Hello,
I want to know is it possible to pass a block of sentence using bash.
For example,
I have a script called Test.sh that takes in $1 and $2.
and I'm calling Test.sh in a.sh
so
in a.sh
Test.sh '' 'This is a sentence'
Because block are separated by space so when I do that, I get... (6 Replies)
Discussion started by: katrvu
6 Replies
4. UNIX for Advanced & Expert Users
Hi
Can anyone please let me know how to call unix scripts from sql or plsql ASAP. (2 Replies)
Discussion started by: ksailesh
2 Replies
5. Programming
Hi All,
I am supposed to present the documentation for the PLSQL code (PACKAGES, PROCEDURE, FUNCTIONS) of my application. There are sufficient comments in my code. Has anyone written any Shell Script Utility which can parse the PLSQL code and generate some kind of document ( preferrably HTML not... (1 Reply)
Discussion started by: gauravsachan
1 Replies
6. Shell Programming and Scripting
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. (3 Replies)
Discussion started by: bankimmehta
3 Replies
7. Shell Programming and Scripting
I have written a script which works fine, to remove patterns contained in EXCLUDE.DAT from input.txt
awk 'BEGIN {n=0;while (getline < "EXCLUDE.DAT" > 0){ex=$0;n++}} {for(var in ex){print var "-" ex $0 ;i++}}' input.txt
The last problem I need to solve is how to pass the file... (3 Replies)
Discussion started by: nixie
3 Replies
8. Shell Programming and Scripting
myscript.sh
#!/bin/bash
ARGA=$1
if ; then
echo "${ARGA}:Confirmed"
else
echo "${ARGA}:Unconfirmed"
fi
when I run the above script from the command line, i run it as:
./myscript.sh jsmith
now some times, i need to runn it this way: (8 Replies)
Discussion started by: SkySmart
8 Replies
9. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
2. Relevant commands, code, scripts, algorithms:
#! /bin/ksh
v="ORG_ID"
... (2 Replies)
Discussion started by: sujitdas2104
2 Replies
10. UNIX for Beginners Questions & Answers
I just want to make sure I am understanding how to pass a config file to a bash script . In the below I pass to arguments to a script, then define them in the script as id and config. I then source config using ., if I understand correctly the variables in the config file can now be used by the... (11 Replies)
Discussion started by: cmccabe
11 Replies
LEARN ABOUT REDHAT
set_session_authorization
SET SESSION
AUTHORIZATION(7) SQL Commands SET SESSION AUTHORIZATION(7)
NAME
SET SESSION AUTHORIZATION - set the session user identifier and the current user identifier of the current session
SYNOPSIS
SET [ SESSION | LOCAL ] SESSION AUTHORIZATION username
SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT
RESET SESSION AUTHORIZATION
DESCRIPTION
This command sets the session user identifier and the current user identifier of the current SQL-session context to be username. The user
name may be written as either an identifier or a string literal. The session user identifier is valid for the duration of a connection;
for example, it is possible to temporarily become an unprivileged user and later switch back to become a superuser.
The session user identifier is initially set to be the (possibly authenticated) user name provided by the client. The current user identi-
fier is normally equal to the session user identifier, but may change temporarily in the context of ``setuid'' functions and similar mecha-
nisms. The current user identifier is relevant for permission checking.
The session user identifier may be changed only if the initial session user (the authenticated user) had the superuser privilege. Other-
wise, the command is accepted only if it specifies the authenticated user name.
The SESSION and LOCAL modifiers act the same as for the regular SET [set(7)] command.
The DEFAULT and RESET forms reset the session and current user identifiers to be the originally authenticated user name. These forms are
always accepted.
EXAMPLES
SELECT SESSION_USER, CURRENT_USER;
current_user | session_user
--------------+--------------
peter | peter
SET SESSION AUTHORIZATION 'paul';
SELECT SESSION_USER, CURRENT_USER;
current_user | session_user
--------------+--------------
paul | paul
COMPATIBILITY
SQL99
SQL99 allows some other expressions to appear in place of the literal username which are not important in practice. PostgreSQL allows iden-
tifier syntax ("username"), which SQL does not. SQL does not allow this command during a transaction; PostgreSQL does not make this
restriction because there is no reason to. The privileges necessary to execute this command are left implementation-defined by the stan-
dard.
SQL - Language Statements 2001-04-21 SET SESSION AUTHORIZATION(7)