04-22-2008
It is working fine now, I changed the printf from printf("exec abc_ert(%s, %s, %s, %s, %s, %s);\n",
$tr , $ap, $ver, $irver, $recdate, $logdate) > sql_file;
to
printf("set serveroutput on format wrap;\nexec abc_ert(%s, %s, %s, %s, %s, %s);\n exit;\n", $tr , $ap, $ver, $irver, $recdate, $logdate) > sql_file;
The problem was exit statement was missing!!!
Amazing solution to very complex problem we encountered. Thanks to all.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi Guys,
I spend half a day getting this to work with no luck, perhaps you guys can help..
I have a string from a file looking like this:
module::name=test::type=generic_data::exec=snmpget.......::desc=A Little Test::interval=300
what I would like to split it, so I get a value for each... (3 Replies)
Discussion started by: hyber
3 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I have a directory file name:
/auto/space/user/jen/CED/CED_01MZ/visit1/DCE_2eco/016/echo1
I would like to just get the following outputs into variables such that:
variable1 = /auto/space/user/jen/CED/CED_01MZ/visit1/
and
variable2 = DCE_2eco/016/echo1
I've tried it with... (2 Replies)
Discussion started by: nixjennings
2 Replies
3. Shell Programming and Scripting
hi guys,
i want to parse a file using public function, the file contain raw data in the below format i want to get the output like this to load it to Oracle DB
MARWA1,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00
MARWA2,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00
this the file raw format:
Number of... (6 Replies)
Discussion started by: dagigg
6 Replies
4. Shell Programming and Scripting
Hi,
I would like to parse the next output of an lvdisplay -v using awk:
--- Logical volumes ---
LV Name /dev/vg01/lvol3
VG Name /dev/vg01
LV Permission read/write
LV Status available/syncd
Mirror copies ... (2 Replies)
Discussion started by: RuBiCK
2 Replies
5. Shell Programming and Scripting
Hi folks,
I have XML files with the following sections (section occurs once per file) in them:
<AuthorList CompleteYN="Y">
<Author ValidYN="Y">
<LastName>Bernal</LastName>
<ForeName>Federico</ForeName>
... (3 Replies)
Discussion started by: euval
3 Replies
6. Shell Programming and Scripting
Hi guys (and gals).
I need some help. I'm running an IVR purely on Asterisk where I capture the DTMFs. After pulsing each DTMF I have Asterisk write to a file with whatever was dialed (mostly used for record-keeping) and at the end of the survey I write all variables in a single line to a... (2 Replies)
Discussion started by: tulf210
2 Replies
7. Shell Programming and Scripting
Input File
Defined configuration:
cfg: CLL_DCC_Fabric_A
BTS00P21; BAU_AP00P01QC; BAU_LGSCNJP02; BAU_TS00P20;
BAU_DSMSM14; BAU_HT00P02; BAU_DSMSM13; BAU_HT00P01;
cfg: CX0014_list
BAU_TS00P20; BAU_NYP_PRODIAD1_CJ;... (5 Replies)
Discussion started by: greycells
5 Replies
8. Shell Programming and Scripting
Hi Experts,
I am trying to parse the following file;
FILEA
a|b|c|c|c|c
a|b|d|d|d|d
e|f|a|a|a|a
e|f|b|b|b|boutput expected:
a<TAB>b
<TAB><TAB>c<TAB>c<TAB>c<TAB>c<TAB>
<TAB><TAB>d<TAB>d<TAB>d<TAB>d<TAB>
e<TAB>f
<TAB><TAB>a<TAB>a<TAB>a<TAB>a<TAB>
<TAB><TAB>b<TAB>b<TAB>b<TAB>b<TAB>*... (7 Replies)
Discussion started by: rajangupta2387
7 Replies
9. Shell Programming and Scripting
Output of the below code includes unmatched date.Please correct it
df -k|awk '$4>50 {print $1, "\t"$4,"\t" $7}'
It gives output less than 50% also. (5 Replies)
Discussion started by: vinil
5 Replies
10. Shell Programming and Scripting
Hi all, I have a file that contains a good hundred of these job definitions below:
Job Name Last Start Last End ST Run Pri/Xit
________________________________________________________________ ____________________... (7 Replies)
Discussion started by: atticuss
7 Replies
LEARN ABOUT PHP
mysqli_ping
MYSQLI_PING(3) 1 MYSQLI_PING(3)
mysqli::ping - Pings a server connection, or tries to reconnect if the connection has gone down
Object oriented style
SYNOPSIS
bool mysqli::ping (void )
DESCRIPTION
Procedural style
bool mysqli_ping (mysqli $link)
Checks whether the connection to the server is working. If it has gone down, and global option mysqli.reconnect is enabled an automatic
reconnection is attempted.
This function can be used by clients that remain idle for a long while, to check whether the server has closed the connection and recon-
nect if necessary.
PARAMETERS
o $
link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
mysqli::ping example
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if ($mysqli->connect_errno) {
printf("Connect failed: %s
", $mysqli->connect_error);
exit();
}
/* check if server is alive */
if ($mysqli->ping()) {
printf ("Our connection is ok!
");
} else {
printf ("Error: %s
", $mysqli->error);
}
/* close connection */
$mysqli->close();
?>
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
/* check if server is alive */
if (mysqli_ping($link)) {
printf ("Our connection is ok!
");
} else {
printf ("Error: %s
", mysqli_error($link));
}
/* close connection */
mysqli_close($link);
?>
The above examples will output:
Our connection is ok!
PHP Documentation Group MYSQLI_PING(3)