and creating a ksh script with below code in it.
while running the above script, It connects me to the oracle database but its not executing the procedure 'entry_to_employees_result'. Then, writing EXIT manually i am getting the below mentioned error:
Can anyone help me out of this.
Regards
Oracle User
Last edited by Franklin52; 02-23-2011 at 03:28 AM..
Reason: Please use code tags, thank you
Hi I am getting this error while connecting to sql through a shell script, whereas i am able to connect to sql directly.
It was working properly earlier, no clue why i am getting this.
Please find the log below:
FTP to <IP> completed Wed Apr 30 11:42:01 BST 2008
Program ended. Wed Apr 30... (1 Reply)
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)
Hi,
I m trying to connect oracle database from inside while loop.
I m trying to put the output of sql query in a flat file.
Anyone please help me out.
cat $FILE_NAME | \
while read da_name
do
$ORACLE_HOME/bin/sqlplus -s user_name/password@instance << EOF >> $OUTPUT_FILE
select... (3 Replies)
Hi all,
I am satyakiran , i am new to the forum. i never done shell scripts for connecting to the data base (oracle) and fetching the data from the database( thru sql select statements ) i want to know
1. how to connect to the data base(oracle) using shell script
2. how to retrieve data... (8 Replies)
Hi, I have problems with running shell script connecting to Oracle from the crontab. Here is the script:
#!/sbin/sh
ORACLE_HOME=/opt/oracle/10g/
export ORACLE_HOME
if
then
echo "Source path is not specified"
exit
fi
/opt/oracle/10g/bin/sqlplus user/pass@testdb << EOF
truncate table... (6 Replies)
Hi :),
I have installed CA Autosys in my Unix system. It contains 3 ( .pm ) files namely AutoSys.pm, Job.pm, Status.pm ....... in a directory CA.
Am trying to work with autosys for first time. Please guide in how do i connect autosys to oracle DB in my system. My oracle db name is XE..
Thank... (0 Replies)
Hi :),
Am new to work with Autosys. I have Oracle installed in my computer. Please guide me how to configure and connect autosys with oracle database.
thank you..!:) (0 Replies)
Hi,
I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following:
1. Connect to oracle database hosted on a different server
2. fire a query on the oracle db
3. store the output in a variable
4. use this variable for further logic... (1 Reply)
Hai
i want to connect to oracle database from user input and create a view.
${ECHO} "Debut Creating View"
${ECHO} "Please Enter the User Name:"
read user_name
${ECHO} "Please Enter the Connection String:"
read con_string
${ECHO} "Please Enter the Password:"
read pwd... (3 Replies)
Hi guys, long time no typing :D
I have problems when I try to connect to Oracle database from SQL Developer which is located on my Windows box.
Server is running Solaris 11/11 and Oracle 11 enterprise. I can log in locally with sys account to database, start it up and shut it down but when I... (2 Replies)
Discussion started by: solaris_user
2 Replies
LEARN ABOUT PHP
php_uname
PHP_UNAME(3) 1 PHP_UNAME(3)php_uname - Returns information about the operating system PHP is running onSYNOPSIS
string php_uname ([string $mode = "a"])
DESCRIPTION php_uname(3) returns a description of the operating system PHP is running on. This is the same string you see at the very top of the
phpinfo(3) output. For the name of just the operating system, consider using the PHP_OS constant, but keep in mind this constant will con-
tain the operating system PHP was built on.
On some older UNIX platforms, it may not be able to determine the current OS information in which case it will revert to displaying the OS
PHP was built on. This will only happen if your uname() library call either doesn't exist or doesn't work.
PARAMETERS
o $mode
-$mode is a single character that defines what information is returned:
o 'a': This is the default. Contains all modes in the sequence "s n r v m".
o 's': Operating system name. eg. FreeBSD.
o 'n': Host name. eg. localhost.example.com.
o 'r': Release name. eg. 5.1.2-RELEASE.
o 'v': Version information. Varies a lot between operating systems.
o 'm': Machine type. eg. i386.
RETURN VALUES
Returns the description, as a string.
EXAMPLES
Example #1
Some php_uname(3) examples
<?php
echo php_uname();
echo PHP_OS;
/* Some possible outputs:
Linux localhost 2.4.21-0.13mdk #1 Fri Mar 14 15:08:06 EST 2003 i686
Linux
FreeBSD localhost 3.2-RELEASE #15: Mon Dec 17 08:46:02 GMT 2001
FreeBSD
Windows NT XN1 5.1 build 2600
WINNT
*/
if (strtoupper(substr(PHP_OS, 0, 3)) === 'WIN') {
echo 'This is a server using Windows!';
} else {
echo 'This is a server not using Windows!';
}
?>
There are also some related Predefined PHP constants that may come in handy, for example:
Example #2
A few OS related constant examples
<?php
// *nix
echo DIRECTORY_SEPARATOR; // /
echo PHP_SHLIB_SUFFIX; // so
echo PATH_SEPARATOR; // :
// Win*
echo DIRECTORY_SEPARATOR; //
echo PHP_SHLIB_SUFFIX; // dll
echo PATH_SEPARATOR; // ;
?>
SEE ALSO phpversion(3), php_sapi_name(3), phpinfo(3).
PHP Documentation Group PHP_UNAME(3)