10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Trying to run the Oracle Proc in parallel, but not working.. below code runs each call of the procedure and its coming out of the loop before its completion and printing the last statement! not waiting for the sqlplus to complete.
for name in `cat abc.txt`
(sqlplus -s ... (3 Replies)
Discussion started by: ATWC
am making oracle connection through pro*c using the following command
exec sql connect username identified by password.
but m getting the following errors frequently even though listener and db is running fine but some times code is working fine and not giving errors.
... (2 Replies)
Discussion started by: senkerth
3. Shell Programming and Scripting
I've a Centralized Server which can connect to all Oracle Databases.
When I was trying the below code it doesn't work, But tnsping was working fine.
my $dbh = DBI->connect('dbi:Oracle:QBDIWCE', 'IDUSER', 'SECRET123#' ) || die( $DBI::errstr . "\n" ) ;
... (1 Reply)
Discussion started by: ilugopal
4. UNIX and Linux Applications
I have a very simple set up
I am connecting to a MS SQL db using SQSH statement from a shell script
In this sqsh connection i am trying to execute a stored proc
However I want to capture the value returned by the stored proc.
I haven't really come across anything useful so far which would... (0 Replies)
Discussion started by: shishirkotkar
5. Shell Programming and Scripting
Will I be able to connect to oracle using UBUNTU. If so, can any one provide me the steps. I want to try table archival and sql loader using control files. Please do help.
Raaga (1 Reply)
Discussion started by: Raaga
6. Shell Programming and Scripting
My problem is this....:eek:
Platform=Sun Solaris UNIX / Oracle 10g
1) I'm trying to SSH from my local system A to remote system B
2) Once connected, I need to sudo to ID that has the ability to connect to the Oracle database
3) Then run a script that connects via sqlplus and... (2 Replies)
Discussion started by: khand67
7. UNIX for Dummies Questions & Answers
Hi. I need sime help with a unix script. The script runs a Oracle Procedure which then runs
some child procedures which are autonomous.
When the child procedures fail, the sql error is not passed back to the parent procedure -
i.e all the othert child procedures run.
I want to execute the... (0 Replies)
Discussion started by: Zdnas_79
8. Windows & DOS: Issues & Discussions
I am attempting to access an Oracle 9i database located on a Solaris server from an XP client. The server is running Oracle 9i184.108.40.206.0 and the XP is Oracle client 9i 220.127.116.11.0. When I start a listener on the server, the listener starts but I receive a message “The listener supports no services”. I... (3 Replies)
Discussion started by: jkuchar747
9. Shell Programming and Scripting
I'm trying to get this right, please can you help. In my unix korn shell script, I call an oracle stored proc within a package and I specify 3 parameters, 2 of which are IN OUT parameters (i.e. I expect the stored proc to change them and return them back to me).
Does the unix code... (7 Replies)
Discussion started by: csong2
10. UNIX for Advanced & Expert Users
Using a shell script I have to check the 4 values from a table in Oracle and then store the result as "Y" in a Unix variable if the values are desired and "N" if the values are not desired.
There is a table abc in oracle which has 4 fields. if all the four values... (2 Replies)
Discussion started by: decci_7