|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
sqlplus and dbms_output.put_line in shell script
Post 302152519 by ranjithpr on Thursday 20th of December 2007 04:39:11 AM
12-20-2007
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i'm having real problems retrieving the returncode of my sqlplus-call. I found a lot of informations on the net, but havn't been able to get it running so far, so now i ask for some help ;)
I do start the sqlplus out of my shell script with the parameters stored in the proc_clips.sql, which is... (6 Replies)
Discussion started by: maco_home
6 Replies
2. Shell Programming and Scripting
Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files..
Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this?
Please tell me... (2 Replies)
Discussion started by: Hara
2 Replies
3. Shell Programming and Scripting
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Discussion started by: praka
6 Replies
4. Shell Programming and Scripting
Hi
I want to connect to the Oracle database using a username/password and get back the query result(a numeric value) in a variable, which I can then compare using a conditional.
Can anybody help me with this.
Thanks
Gaurav (4 Replies)
Discussion started by: gaurav_1711
4 Replies
5. Shell Programming and Scripting
Hi All,
How i will use sqlplus in shell script?
Can any one provide sample code which explain following:
1. Connect to oracle DB
2. Exceute select * from tablename
3. Release connection to the DB
4. Append output in file everytime when query executes.
Thanks in advance (1 Reply)
Discussion started by: poweroflinux
1 Replies
6. Programming
Dear All,
As I'm new here, please forgive me if any rule violation occurred.
I have a script like this:
#! /bin/ksh
# Author : Saptarshi
# Date : 18-Mar-2011
# Version : 1.0
Return_op=`sqlplus -s <<ENDOFSQL
db_user/db_pass@db_nm
WHENEVER SQLERROR EXIT 1
set ... (1 Reply)
Discussion started by: saps19
1 Replies
7. Shell Programming and Scripting
Hi
When I use sqlplus in shell script, I get sqlplus: command not found.
ORACLE_HOME is not set. How to set ORACLE_HOME in unix?
Thanks (3 Replies)
Discussion started by: vinoth_kumar
3 Replies
8. Shell Programming and Scripting
Hi All,
I Have written a script through that i am calling sql file
Sqlfile.sql
set time on
set timing on
set echo on
set head off
set scan on
set feedback on
set serveroutput on
set linesize 1000
DECLARE
v_acc_no NUMBER(10);
v_product_no NUMBER(10);
BEGIN... (3 Replies)
Discussion started by: sujit_kashyap
3 Replies
9. Shell Programming and Scripting
Hi All,
Please let me know what i am missing in the following code (part of my script)
Schemas=(AWQM WFCONTROLLER PROVCO PRISM)
for s in "${Schemas}"
do
sch="${s}_$tol"
if || ;then
echo "This is AD or TD region"
sqlplus -s $sch/$tpwd@$ttns <<EOF... (7 Replies)
Discussion started by: pvmanikandan
7 Replies
10. Shell Programming and Scripting
Hello,
I'm trying to print the value of my cursor in the dbms_output.put_line in shell script, but it only shows "PL/SQL procedure successfully completed." nothing else. I have set serveroutput on,
Below is my script : Any advise would be really helpful.
sqlplus -s $ORACLE_LOGON <<EOF >>... (2 Replies)
Discussion started by: mail.chiranjit
2 Replies
LEARN ABOUT SUNOS
sasl_server_step
sasl_server_step(3SASL) Simple Authentication Security Layer Library Functions sasl_server_step(3SASL) NAME
sasl_server_step - perform a step in the server authentication negotiation SYNOPSIS
cc [ flag ... ] file ... -lsasl [ library ... ] #include <sasl/sasl.h> int sasl_server_step(sasl_conn_t *conn, const char *clientin, unsigned clientinlen, const char **serverout, unsigned *serveroutlen); DESCRIPTION
The sasl_server_step() performs a step in the authentication negotiation. PARAMETERS
conn The SASL context for this connection. clientin The data given by the client. The data is decoded if the protocol encodes requests that are sent over the wire. clientinlen The length of clientin. serverout Set by the library and sent to the client. serveroutlen RETURN VALUES
sasl_server_step() returns an integer that corresponds to a SASL error code. ERRORS
SASL_OK The whole authentication completed successfully. SASL_CONTINUE The call to sasl_server_step() was successful, and at least one more step is needed for the authentication. All other error codes indicate an error situation that you must handle, or you should quit the authentication session. See sasl_errors(3SASL) for information on SASL error codes. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWlibsasl | +-----------------------------+-----------------------------+ |Interface Stability |Evolving | +-----------------------------+-----------------------------+ |MT-Level |MT-Safe | +-----------------------------+-----------------------------+ SEE ALSO
sasl_errors(3SASL), attributes(5) SunOS 5.10 14 Oct 2003 sasl_server_step(3SASL)