10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
HI Experts,
I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into
the table.
Also i... (1 Reply)
Discussion started by: sam1234
1 Replies
2. UNIX for Dummies Questions & Answers
HI Experts,
I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into
the table.
Also i... (1 Reply)
Discussion started by: sam1234
1 Replies
3. UNIX for Advanced & Expert Users
I am running the xampp on WINDOWS, and my php script is connecting to a unix script on a different server (ssh2_connect("11.31.138.56", 22). I am running the unix script and inside this script I am calling the .sql file . The SQL is connecting to oracle db on the unix server.
But the sqlplus... (2 Replies)
Discussion started by: madfox
2 Replies
4. UNIX for Advanced & Expert Users
Hi Experts:
I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
3 Replies
5. Shell Programming and Scripting
hi,
I want to know how to call a pl sql function testfunction(param1,..) that returns a value and grab that value in a shell variable.
Thnx in advance
---------- Post updated 03-30-10 at 11:58 AM ---------- Previous update was 03-29-10 at 03:49 PM ----------
thnx a lot jim (0 Replies)
Discussion started by: austinhell3_16
0 Replies
6. Shell Programming and Scripting
HI,
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
7 Replies
7. UNIX for Advanced & Expert Users
Hi All
I would be thankful to you all if you will guide me the steps to call a stored proc. from unix shell script. that stored proc. could be parameterised or parameterless developed in SQL.
Any info. in this topic would help me.....
Thanks in advance.... (1 Reply)
Discussion started by: varungupta
1 Replies
8. UNIX for Dummies Questions & Answers
Hi GURUs,
I have following queries:
1) If its possible to configure Microsoft SQL Server database on a UNIX machine, if yes, can any body pls point me to the guide to acheive the same.
2) I know Oracle runs perfectly on UNIX based machines, can any body point me to the guide to achieve the... (6 Replies)
Discussion started by: patras
6 Replies
9. Shell Programming and Scripting
who can show me how to call pl/sql function or precudure in unix script..
cheers, (6 Replies)
Discussion started by: YoYo
6 Replies
10. Shell Programming and Scripting
sample code as following:
test_sql(){
#test#echo test_sql
str=`$ORACLE_BIN/sqlplus -s $user/$passwd <<EOM
set verify off
set heading off
set feedback off
#--------start pl/sql
{
DECLARE
CURSOR pah_cs IS
select id from table
where letter = 'abcd';... (6 Replies)
Discussion started by: YoYo
6 Replies
MSSQL_CONNECT(3) MSSQL_CONNECT(3)
mssql_connect - Open MS SQL server connection
SYNOPSIS
resource mssql_connect ([string $servername], [string $username], [string $password], [bool $new_link = false])
DESCRIPTION
mssql_connect(3) establishes a connection to a MS SQL server.
The link to the server will be closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling
mssql_close(3).
PARAMETERS
o $servername
- The MS SQL server. It can also include a port number, e.g. hostname:port (Linux), or hostname,port (Windows).
o $username
- The username.
o $password
- The password.
o $new_link
- If a second call is made to mssql_connect(3) with the same arguments, no new link will be established, but instead, the link
identifier of the already opened link will be returned. This parameter modifies this behavior and makes mssql_connect(3) always
open a new link, even if mssql_connect(3) was called before with the same parameters.
RETURN VALUES
Returns a MS SQL link identifier on success, or FALSE on error.
CHANGELOG
+--------+------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+------------------------------------+
| 5.1.0 | |
| | |
| | The $new_link parameter was added |
| | |
+--------+------------------------------------+
EXAMPLES
Example #1
mssql_connect(3) example
<?php
// Server in the this format: <computer><instance name> or
// <server>,<port> when using a non default port number
$server = 'KALLESPCSQLEXPRESS';
// Connect to MSSQL
$link = mssql_connect($server, 'sa', 'phpfi');
if (!$link) {
die('Something went wrong while connecting to MSSQL');
}
?>
SEE ALSO
mssql_close(3), mssql_pconnect(3).
PHP Documentation Group MSSQL_CONNECT(3)