02-26-2009
Here is a sample code for connecting to Oracle from unix...
Try modifying your script accordingly. Problem could be because you have not used SET commands inside the script
flag=`sqlplus -s<<-EOsqlplus
$Login/$psswd@$con_strng
WHENEVER SQLERROR EXIT SQL.SQLCODE
WHENEVER OSERROR EXIT FAILURE
SET TERM OFF
SET HEAD OFF
SET VERIFY OFF
SET FEEDBACK OFF
select to_char(sysdate,'yyyymmdd') from dual;
EXIT;
EOsqlplus`
Change the above select query and give yours.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
....does the dbms_output.put_line work inside unix shell script?
i mean this is to be inside the sqlplus connection as follows!!
sqlplus -s $UP <<EOJ
..
..
..
dbms_output.put_line ('Insertion procedure failed for UPC BC : ' || wk_key_value || ' Sqlcode: ' || SQLCODE || ' Error... (2 Replies)
Discussion started by: mexx_freedom
2 Replies
2. Shell Programming and Scripting
How to embed a shell script into a C++ program...do kinbdly help me by giving an example....
Thanking you... (1 Reply)
Discussion started by: vas_dba
1 Replies
3. UNIX for Advanced & Expert Users
Hi,
Can some one help me in connecting to oracle through unix shell scripts with examples.
Regards
Narayana Gupta (1 Reply)
Discussion started by: guptan
1 Replies
4. Shell Programming and Scripting
Guys
I have the file TEST.csv generated after a join of two different files with the same columns:
key,string,data,number,key,string,data,number
abc,test,020202,3,abc,test,010305,4
abc,level,070202,9,abc,tool,010203,7
def,tool,010101,7,,,,
ghi,,,ghi,test,010203,8
I have to generate a... (2 Replies)
Discussion started by: Rafael.Buria
2 Replies
5. Shell Programming and Scripting
if;
sql="select username from dba_users where username = '$FromUser';"
check_FromUser=`ExecSql "$sql"`
I want to connect to Oracle database & check the users in the database, store the value in check_FromUser.
First how to connect to Oracle database from the shell script ?
Appreciate your... (4 Replies)
Discussion started by: dreams5617
4 Replies
6. Shell Programming and Scripting
Hi all,
I have command to connect gateway server
iam in home directory/> ssh root@mrp-gateway
root@mrp-gateway:/root> sftp -v msgGoogle@126.132.45.123
sftp/>dir
upload --> folder
sftp/upload/ls
-------------
8990.txt
kittu.txt
8989.txt
i have an requirement to print files list which... (2 Replies)
Discussion started by: kittusri9
2 Replies
7. Shell Programming and Scripting
Hi All,
I have a requirement where I need to connect to Oracle database which is installed on WINDOWS machine.
I dont have Oracle client installed on my AIX so i can't use SQLPLUS command.
But ODBC to connect to Oracle is configured on my UNIX server. Can any one help me with the steps of... (1 Reply)
Discussion started by: Raamc
1 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I need some help regarding oracle with unix script
Actually i have a shell script and i want that it gets triggered through a oracle Db.I dont have any idea how is it done, even whether it is possible....pls help.....!!!! (3 Replies)
Discussion started by: fidelis
3 Replies
9. Shell Programming and Scripting
I have a table called CLARIFICATION in one of my schema in Oracle Data Base. I have to connect to oracle Data Base from Unix and compare the one of the column(Exec_Date) in CLARIFICATION table with Sysdate.If Exec_Date = Sysdate go head and run rest of the script otherwise exit out with out... (2 Replies)
Discussion started by: veeru
2 Replies
10. Shell Programming and Scripting
Hi friends,
I am new to UNIX.
I going to transfer files using SFTP. I am writing a script and using mget .
If i am using mget * means,
if all the files and their sub directories are transferred or not?
If suppose , the local system dose not have the sub directory then what will... (1 Reply)
Discussion started by: punitha
1 Replies
LEARN ABOUT PHP
oci_set_module_name
OCI_SET_MODULE_NAME(3) OCI_SET_MODULE_NAME(3)
oci_set_module_name - Sets the module name
SYNOPSIS
bool oci_set_module_name (resource $connection, string $module_name)
DESCRIPTION
Sets the module name for Oracle tracing.
The module name is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL statement
is executed.
The name can subsequently be queried from database administration views such as V$SESSION. It can be used for tracing and monitoring such
as with V$SQLAREA and DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE.
The value may be retained across persistent connections.
PARAMETERS
o $connection
-An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3).
o $module_name
- User chosen string up to 48 bytes long.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
NOTES
Note
Oracle version requirement
This function is available when PHP is linked with Oracle Database libraries from version 10 g onwards.
Tip
Performance
With older versions of OCI8 or the Oracle Database, the client information can be set using the Oracle DBMS_APPLICATION_INFO pack-
age. This is less efficient than using oci_set_client_info(3).
Caution
Roundtrip Gotcha
Some but not all OCI8 functions cause roundtrips. Roundtrips to the database may not occur with queries when result caching is
enabled.
EXAMPLES
Example #1
Setting the module name
<?php
$c = oci_connect('hr', 'welcome', 'localhost/XE');
// Record the module
oci_set_module_name($c, 'Home Page');
// Code that causes a roundtrip, for example a query:
$s = oci_parse($c, 'select * from dual');
oci_execute($s);
oci_fetch_all($s, $res);
sleep(30);
?>
// While the script is running, the administrator can see the
// modules in use:
sqlplus system/welcome
SQL> select module from v$session;
SEE ALSO
oci_set_action(3), oci_set_client_info(3), oci_set_client_identifier(3).
PHP Documentation Group OCI_SET_MODULE_NAME(3)