Oracle Query results to be stored in variables using unix
I want to store the sql query output into a variable
------------
The output expecting is
Enter the Malformed Order ....!
PO-DBMBDWG
Regrade check : PO-DBMBDWG
out put is : N
But when i tried executing the above scripting its throwing an error
Quote:
Enter the Malformed Order ....!
PO-DBMBDWG
Regrade check : PO-DBMBDWG
out put is ERROR:
ORA-01741: illegal zero-length identifier
The functionallity of the script is
1. value is passed through the command prompt
2. Passing the command line arguement to the sql query input
3. The sql query result has to be stored in a variable
I have created 3 Procedures all similar to this one:
I then created 3 shell sripts which will call the sql? finally created a calling script to call the procedure. I am a bit unsure how to this all works, can someone check my code and I am doing this right? Also could I add my procedure (first... (0 Replies)
Hi All,
I needed to get the result of two sqlplus queris into shell variables.
After days of looking for the ultimate solution to this problem.. i found this...
sqlplus -s USER/PASS@DB <<EOF | awk '{if(NR==1) printf("%s ", $1); if(NR==2) printf("%s ",
$1);}' | read VAR1 VAR2
set head off... (2 Replies)
Hi
I would like to know if there is a way to just have one ORACLE connection established, using which we can execute different queries and store the results under different variables.
For e.g the following uses to two silent ORACLE connection to store the result under two different... (4 Replies)
Hi
i am calling a stored procedure from unix shell like this call
test_proc('0002','20100218');
the stored procedure was giving output
like this dbms_output.put_line(' processed earlier');
i want to see the output in the unix shell where i called.
Thanks
barani (6 Replies)
Hi
i want to call a oracle stored procedure from unix (using bash shell).
consider this is my oracle stored procedure with parameter
create procedure testproc(name IN varchar, age IN Number, id OUT Number )
AS
begin
id=1;
dbms_output.put.line('successfull validation')
end;... (6 Replies)
While assisting a forum member, I recommended running SQL/Plus in a coprocess (to make database connections and run a test script) for the duration of his script rather than starting/stopping it once for every row in a file he was processing.
I recalled I made a coprocess example for folks at... (2 Replies)
Hello,
I am very new to shell scripting and I am not sure of how best to handle the following scenario. I need to query a list of values from a table. I need to store those results and use them to selectively delete values in yet another table in a separate database. I do know how to store the... (3 Replies)
Hi,
I am new to linux...
How to Assign SQL Query Results to Variables in Linux,i want ti generate it in param files, Can anyone please explain me.
Ex: SQL> Select * from EMP;
O/P: Emp_No Emp_Name
1 AAA
2 BBB
3 CCC
and I want expected... (5 Replies)
Hi Everyone,
I want to create a script where i need to run the oracle stored procedure from unix script and get the output(sequence number ) into a variable which i will pass in my datastage job.
Below is my stored procedure:-
DECLARE
P_TRANSTYPE VARCHAR2(20);
... (4 Replies)
Hi All,
I need to read values of 10 columns from oracle query and assign the same to 10 unix variables. The query will return only one record(row).
I tried to append all these columns using a delimiter(;) in the select query and assign the same to a single variable(V) in unix. I thought I... (3 Replies)
Discussion started by: hkrishnan91
3 Replies
LEARN ABOUT SUNOS
asadmin-export
asadmin-export(1AS) User Commands asadmin-export(1AS)NAME
asadmin-export, export - marks a variable name for automatic export to the environment of subsequent commands in multimode
SYNOPSIS
export [ name=value [ name=value]*]
Marks a variable name for automatic export to the environment of subsequent commands. All subsequent commands use the variable name values
as specified; unless you unset them or exit multimode. If only the variable name is specified, the current value of that variable name is
displayed. If the export command is used without any arguments, a list of all the exported variables and their values is displayed.
Exported shell environment variables set prior to invoking the asadmin utility are imported automatically and set as exported variables
within asadmin. Unexported environment variables cannot be read by the asadmin utility.
OPERANDS
name=value variable name and value for automatic export to the environment to be used by subsequent commands.
Example 1: Using export to list the environment variables
asadmin> export AS_ADMIN_HOST=bluestar AS_ADMIN_PORT=8000 AS_ADMIN_USER=admin AS_ADMIN_PASSWORD=password
asadmin> export AS_ADMIN_PREFIX=server1.jms-service
asadmin> export //to list the environment variables that are set
AS_ADMIN_HOST=bluestar
AS_ADMIN_PORT=8000
AS_ADMIN_USER=admin
AS_ADMIN_PASSWORD=********
AS_ADMIN_PREFIX=server1.jms-service
Where: the export command lists the environment variables that are set. In this case, the environment variables have been set to: the host
is bluestar, the port is 8000, the administrator user is admin with an associated password, and the prefix is server1.jms-service.
EXIT STATUS
0 command executed successfully
1 error in executing the command
asadmin-unset(1AS), asadmin-multimode(1AS)J2EE 1.4 SDK March 2004 asadmin-export(1AS)