PDA

View Full Version : Hide Tables and headers on clicking the submit button

zee_no
05-08-2008, 07:53 AM
Hey,

I have six HMTL tables on my web page.

The first table is a table which contains some input fields and a submit button and a drop down list, the other five tables have data and are preceded by a header <h3>

When one selects a particular item from the drop down list and hit the submit button all the tables and the header other than the select item should hide. I am not getting how to do so as i have 6 tables and 5 headers tags. I used a for loop.

I have posted my code below:

<html>
<head>
<body>

<html>
<body>
<table cellspacing="1" cellpadding="2" border="0">
<tbody>
<tr>
<td>From Date:</td>
<td><input type="text" id="fromDate" /></td>
</tr>
<tr>
<td>To Date:</td>
<td><input type="text" id="toDate" /></td>
</tr>
<tr><td>Database Name:</td><td><select name="Databases" id="chk">
<option value="TBSU">TBSU</option>
<option value="ABNAPR">ABNAPR</option>
<option value="CPRUDT">CPRUDT</option>
<option value="WMSUAT">WMSUAT</option>
<option value="JAGPROD">JAGPROD</option>
</select>
</td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="submit" onclick="get_data()"></td>
</tr>
</tbody>
</table>

<script type="text/javascript">
function get_data()
{
var x=document.getElementsByTagName("H3");
var y=document.getElementsByTagName("table");
var z=document.getElementById("chk");
var b=document.getElementById("chk").value;
for(var i=0; i<y.length; i++)
{
var b=document.getElementById("chk").value;
if(y[i].rows[0].cells[0].innerHTML=="ORA ERROR")
{
for(var i=0; i<y.length; i++)
{
if(y[i].rows[0].cells[1].innerHTML=="Timestamp")
{
for(var j=0; j<x.length; j++)
{
var a=x[j].innerHTML;
var b=document.getElementById("chk").value;
if(b==a)
{
x[j].style.display="";
y[i].style.display="";
}
else
{
x[j].style.display="none";
y[i].style.display="none";
}
}
}
else
{
alert("Not Working");
}
}
}

}
}

</script>


The first table is creating problems and not giving me the desired output.

Thanks,

Zee
rangana
05-08-2008, 08:00 AM
One obvious mistake is highlighted:

<input type="submit" value="submit" onclick="get_Data()">


JS is case sensitive. You have:

get_data()


Also, you're not closing your first for loop, as well as your function:
...add two brackets } in your script.
zee_no
05-08-2008, 08:04 AM
hey,

I must have made those mistakes in copy paste...still the code does not give me the desired output. It always displays two tables on the screen. The item selected table and the table before it.
rangana
05-08-2008, 09:22 AM
I can't see any other tables in the code you've provided. (Difficult for me to point where the fix should be). ;)
zee_no
05-08-2008, 09:36 AM
I cant copy paste the entire page if you want i will copy the entire web page with all the tables


<html>
<head>
<body>

<html>
<body>
<table cellspacing="1" cellpadding="2" border="0">
<tbody>
<tr>
<td>From Date:</td>
<td><input type="text" id="fromDate" /></td>
</tr>
<tr>
<td>To Date:</td>
<td><input type="text" id="toDate" /></td>
</tr>
<tr><td>Database Name:</td><td><select name="Databases" id="chk">
<option value="TBSU">TBSU</option>
<option value="ABNAPR">ABNAPR</option>
<option value="CPRUDT">CPRUDT</option>
<option value="WMSUAT">WMSUAT</option>
<option value="JAGPROD">JAGPROD</option>
</select>
</td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="submit" onclick="get_data()"></td>
</tr>
</tbody>
</table>

<script type="text/javascript">
function get_data()
{
var x=document.getElementsByTagName("H3");
var y=document.getElementsByTagName("table");
var z=document.getElementById("chk");
var b=document.getElementById("chk").value;
for(var i=0; i<x.length; i++)
{

if(y[i].rows[0].cells[0].innerHTML=="ORA ERROR")
{
var a=x[i].innerHTML;
if(b==a)
{
x[i].style.display="";
y[i].style.display="";
}
else
{
x[i].style.display="none";
y[i].style.display="none";
}
}
else
{
}

}
}







</script>
<h3 align="center" name="TBSU">TBSU</h3>

<table border='1' width='90%' align='center' summary='Script output'>
<tr><th>ORA ERROR</th><th>Timestamp</th></tr>
<tr><td>TBSU</td><td>check</td></tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS9 STORAGE(INITIA...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS10 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS11 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS12 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS13 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS14 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS15 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS16 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS17 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS18 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS19 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS20 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS21 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS22 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS23 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS24 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS25 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []
</td>
<td>
Tue Apr 15 15:34:59 2008
</td>
</tr>
<tr>
<td>
ORA-02068: following severe error from DB_10G
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
<tr>
<td>
ORA-12571: TNS:packet writer failure
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
</table>

<h3 align="center" value="CPRUDT">CPRUDT</h3>
<table border='1' width='90%' align='center' summary='Script output'>
<tr><th>ORA ERROR</th><th>Timestamp</th></tr>
<tr><td>PRUDT</td><td>check</td></tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS9 STORAGE(INITIA...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS10 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS11 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS12 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS13 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS14 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS15 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS16 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS17 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS18 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS19 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS20 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS21 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS22 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS23 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS24 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS25 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []
</td>
<td>
Tue Apr 15 15:34:59 2008
</td>
</tr>
<tr>
<td>
ORA-02068: following severe error from DB_10G
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
<tr>
<td>
ORA-12571: TNS:packet writer failure
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
</table>

<h3 align="center" value="JAGPROD">JAGPROD</h3>
<table border='1' width='90%' align='center' summary='Script output'>
<tr><th>ORA ERROR</th><th>Timestamp</th></tr>
<tr><td>JAGPROUD</td><td>check</td></tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS9 STORAGE(INITIA...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS10 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS11 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS12 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS13 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS14 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS15 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS16 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS17 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS18 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS19 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS20 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS21 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS22 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS23 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS24 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS25 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []
</td>
<td>
Tue Apr 15 15:34:59 2008
</td>
</tr>
<tr>
<td>
ORA-02068: following severe error from DB_10G
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
<tr>
<td>
ORA-12571: TNS:packet writer failure
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
</table>

<h3 align="center" value="WMSUAT">WMSUAT</h3>
<table border='1' width='90%' align='center' summary='Script output'>
<tr><th>ORA ERROR</th><th>Timestamp</th></tr>
<tr><td>wmsaut</td><td>check</td></tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS9 STORAGE(INITIA...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS10 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS11 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS12 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS13 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS14 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS15 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS16 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS17 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS18 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS19 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS20 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS21 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS22 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS23 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS24 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS25 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []
</td>
<td>
Tue Apr 15 15:34:59 2008
</td>
</tr>
<tr>
<td>
ORA-02068: following severe error from DB_10G
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
<tr>
<td>
ORA-12571: TNS:packet writer failure
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
</table>

<h3 align="center" value="ABNAPR">ABNAPR</h3>
<table border='1' width='90%' align='center' summary='Script output'>
<tr><th>ORA ERROR</th><th>Timestamp</th></tr>
<tr><td>ABNAPR</td><td>check</td></tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS9 STORAGE(INITIA...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS10 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS11 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS12 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS13 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS14 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS15 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS16 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS17 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS18 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS19 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS20 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS21 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS22 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS23 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS24 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS25 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-1119 signalled during: CREATE TABLESPACE "CPI_DATA"
</td>
<td>
Mon Apr 23 21:06:18 2007
</td>
</tr>
<tr>
<td>
ORA-1119 signalled during: CREATE TABLESPACE "CPI_DATA"
</td>
<td>
Mon Apr 23 21:26:00 2007
</td>
</tr>
<tr>
<td>
ORA-1119 signalled during: CREATE TABLESPACE "CT_CI_DETAIL_BIG"
</td>
<td>
Mon Apr 23 21:48:06 2007
</td>
</tr>
<tr>
<td>
ORA-1119 signalled during: CREATE TABLESPACE "CT_CI_DETAIL_BIG_IND"
</td>
<td>
Mon Apr 23 22:00:22 2007
</td>
</tr>
<tr>
<td>
ORA-1119 signalled during: CREATE TABLESPACE "CT_CI_DETAIL_BIG_IND"
</td>
<td>
Mon Apr 23 22:03:43 2007
</td>
</tr>
</table>


</body>
</head>
</html>
rangana
05-09-2008, 03:20 AM
Apologies for the delay in reply. I'm confused...but then, see if this helps :)

<html>
<body>
<table cellspacing="1" cellpadding="2" border="0">
<tbody>
<tr>
<td>From Date:</td>
<td><input type="text" id="fromDate" /></td>
</tr>
<tr>
<td>To Date:</td>
<td><input type="text" id="toDate" /></td>
</tr>
<tr><td>Database Name:</td><td><select name="Databases" id="chk">
<option value="TBSU">TBSU</option>
<option value="ABNAPR">ABNAPR</option>
<option value="CPRUDT">CPRUDT</option>
<option value="WMSUAT">WMSUAT</option>
<option value="JAGPROD">JAGPROD</option>
</select>
</td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="submit" onclick="get_data()"></td>
</tr>
</tbody>
</table>

<script type="text/javascript">
function get_data()
{
var tbsu=document.getElementById('tbsu');
var abnapr=document.getElementById('abnapr');
var cprudt=document.getElementById('cprudt');
var wmsuat=document.getElementById('wmsuat');
var jagprod=document.getElementById('jagprod');
var opt=document.getElementById('chk');
switch(opt.value)
{
case 'TBSU':
tbsu.style.display='';
break;
case 'ABNAPR':
abnapr.style.display='';
break;
case 'CPRUDT':
cprudt.style.display='';
break;
case 'WMSUAT':
wmsuat.style.display='';
break;
case 'JAPGPROD':
jagprod.style.display='';
break;
}
}
window.onload=function()
{
var tbsu=document.getElementById('tbsu');
var abnapr=document.getElementById('abnapr');
var cprudt=document.getElementById('cprudt');
var wmsuat=document.getElementById('wmsuat');
var jagprod=document.getElementById('jagprod');
tbsu.style.display='none';
abnapr.style.display='none';
cprudt.style.display='none';
wmsuat.style.display='none';
jagprod.style.display='none';
}
</script>
<div id="tbsu">
<h3 align="center" name="TBSU">TBSU</h3>

<table border='1' width='90%' align='center' summary='Script output'>
<tr><th>ORA ERROR</th><th>Timestamp</th></tr>
<tr><td>TBSU</td><td>check</td></tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS9 STORAGE(INITIA...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS10 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS11 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS12 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS13 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS14 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS15 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS16 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS17 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS18 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS19 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS20 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS21 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS22 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS23 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS24 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS25 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []
</td>
<td>
Tue Apr 15 15:34:59 2008
</td>
</tr>
<tr>
<td>
ORA-02068: following severe error from DB_10G
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
<tr>
<td>
ORA-12571: TNS:packet writer failure
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
</table>
</div>

<div id="cprudt">
<h3 align="center" value="CPRUDT">CPRUDT</h3>
<table border='1' width='90%' align='center' summary='Script output'>
<tr><th>ORA ERROR</th><th>Timestamp</th></tr>
<tr><td>PRUDT</td><td>check</td></tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS9 STORAGE(INITIA...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS10 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS11 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS12 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS13 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS14 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS15 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS16 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS17 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS18 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS19 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS20 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS21 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS22 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS23 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS24 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS25 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []
</td>
<td>
Tue Apr 15 15:34:59 2008
</td>
</tr>
<tr>
<td>
ORA-02068: following severe error from DB_10G
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
<tr>
<td>
ORA-12571: TNS:packet writer failure
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
</table>
</div>

<div id="jagprod">
<h3 align="center" value="JAGPROD">JAGPROD</h3>
<table border='1' width='90%' align='center' summary='Script output'>
<tr><th>ORA ERROR</th><th>Timestamp</th></tr>
<tr><td>JAGPROUD</td><td>check</td></tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS9 STORAGE(INITIA...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS10 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS11 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS12 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS13 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS14 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS15 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS16 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS17 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS18 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS19 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS20 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS21 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS22 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS23 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS24 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS25 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []
</td>
<td>
Tue Apr 15 15:34:59 2008
</td>
</tr>
<tr>
<td>
ORA-02068: following severe error from DB_10G
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
<tr>
<td>
ORA-12571: TNS:packet writer failure
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
</table>
</div>

<div id="wmsuat">
<h3 align="center" value="WMSUAT">WMSUAT</h3>
<table border='1' width='90%' align='center' summary='Script output'>
<tr><th>ORA ERROR</th><th>Timestamp</th></tr>
<tr><td>wmsaut</td><td>check</td></tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS9 STORAGE(INITIA...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS10 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS11 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS12 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS13 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS14 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS15 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS16 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS17 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS18 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS19 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS20 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS21 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS22 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS23 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS24 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS25 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []
</td>
<td>
Tue Apr 15 15:34:59 2008
</td>
</tr>
<tr>
<td>
ORA-02068: following severe error from DB_10G
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
<tr>
<td>
ORA-12571: TNS:packet writer failure
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
</table>
</div>

<div id="abnapr">
<h3 align="center" value="ABNAPR">ABNAPR</h3>
<table border='1' width='90%' align='center' summary='Script output'>
<tr><th>ORA ERROR</th><th>Timestamp</th></tr>
<tr><td>ABNAPR</td><td>check</td></tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS9 STORAGE(INITIA...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS10 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS11 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS12 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS13 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS14 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS15 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS16 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS17 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS18 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS19 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS20 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS21 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS22 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS23 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS24 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS25 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-1119 signalled during: CREATE TABLESPACE "CPI_DATA"
</td>
<td>
Mon Apr 23 21:06:18 2007
</td>
</tr>
<tr>
<td>
ORA-1119 signalled during: CREATE TABLESPACE "CPI_DATA"
</td>
<td>
Mon Apr 23 21:26:00 2007
</td>
</tr>
<tr>
<td>
ORA-1119 signalled during: CREATE TABLESPACE "CT_CI_DETAIL_BIG"
</td>
<td>
Mon Apr 23 21:48:06 2007
</td>
</tr>
<tr>
<td>
ORA-1119 signalled during: CREATE TABLESPACE "CT_CI_DETAIL_BIG_IND"
</td>
<td>
Mon Apr 23 22:00:22 2007
</td>
</tr>
<tr>
<td>
ORA-1119 signalled during: CREATE TABLESPACE "CT_CI_DETAIL_BIG_IND"
</td>
<td>
Mon Apr 23 22:03:43 2007
</td>
</tr>
</table>
</div>

</body>
</head>
</html>
rangana
05-09-2008, 04:33 AM
....or something like this: :)

<html>
<body>
<table cellspacing="1" cellpadding="2" border="0">
<tbody>
<tr>
<td>From Date:</td>
<td><input type="text" id="fromDate" /></td>
</tr>
<tr>
<td>To Date:</td>
<td><input type="text" id="toDate" /></td>
</tr>
<tr><td>Database Name:</td><td><select name="Databases" id="chk">
<option value="TBSU">TBSU</option>
<option value="ABNAPR">ABNAPR</option>
<option value="CPRUDT">CPRUDT</option>
<option value="WMSUAT">WMSUAT</option>
<option value="JAGPROD">JAGPROD</option>
</select>
</td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="submit" onclick="get_data()"></td>
</tr>
</tbody>
</table>

<script type="text/javascript">
function get_data()
{
var tbsu=document.getElementById('tbsu');
var abnapr=document.getElementById('abnapr');
var cprudt=document.getElementById('cprudt');
var wmsuat=document.getElementById('wmsuat');
var jagprod=document.getElementById('jagprod');
var opt=document.getElementById('chk');
switch(opt.value)
{
case 'TBSU':
reset();
tbsu.style.display='';
break;
case 'ABNAPR':
reset();
abnapr.style.display='';
break;
case 'CPRUDT':
reset();
cprudt.style.display='';
break;
case 'WMSUAT':
reset();
wmsuat.style.display='';
break;
case 'JAPGPROD':
reset();
jagprod.style.display='';
break;
}
}
function reset()
{
var tbsu=document.getElementById('tbsu');
var abnapr=document.getElementById('abnapr');
var cprudt=document.getElementById('cprudt');
var wmsuat=document.getElementById('wmsuat');
var jagprod=document.getElementById('jagprod');
tbsu.style.display='none';
abnapr.style.display='none';
cprudt.style.display='none';
wmsuat.style.display='none';
jagprod.style.display='none';
}
window.onload=reset;
</script>
<div id="tbsu">
<h3 align="center" name="TBSU">TBSU</h3>

<table border='1' width='90%' align='center' summary='Script output'>
<tr><th>ORA ERROR</th><th>Timestamp</th></tr>
<tr><td>TBSU</td><td>check</td></tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS9 STORAGE(INITIA...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS10 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS11 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS12 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS13 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS14 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS15 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS16 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS17 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS18 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS19 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS20 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS21 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS22 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS23 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS24 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS25 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []
</td>
<td>
Tue Apr 15 15:34:59 2008
</td>
</tr>
<tr>
<td>
ORA-02068: following severe error from DB_10G
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
<tr>
<td>
ORA-12571: TNS:packet writer failure
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
</table>
</div>

<div id="cprudt">
<h3 align="center" value="CPRUDT">CPRUDT</h3>
<table border='1' width='90%' align='center' summary='Script output'>
<tr><th>ORA ERROR</th><th>Timestamp</th></tr>
<tr><td>PRUDT</td><td>check</td></tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS9 STORAGE(INITIA...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS10 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS11 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS12 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS13 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS14 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS15 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS16 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS17 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS18 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS19 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS20 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS21 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS22 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS23 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS24 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS25 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []
</td>
<td>
Tue Apr 15 15:34:59 2008
</td>
</tr>
<tr>
<td>
ORA-02068: following severe error from DB_10G
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
<tr>
<td>
ORA-12571: TNS:packet writer failure
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
</table>
</div>

<div id="jagprod">
<h3 align="center" value="JAGPROD">JAGPROD</h3>
<table border='1' width='90%' align='center' summary='Script output'>
<tr><th>ORA ERROR</th><th>Timestamp</th></tr>
<tr><td>JAGPROUD</td><td>check</td></tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS9 STORAGE(INITIA...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS10 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS11 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS12 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS13 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS14 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS15 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS16 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS17 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS18 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS19 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS20 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS21 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS22 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS23 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS24 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS25 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []
</td>
<td>
Tue Apr 15 15:34:59 2008
</td>
</tr>
<tr>
<td>
ORA-02068: following severe error from DB_10G
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
<tr>
<td>
ORA-12571: TNS:packet writer failure
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
</table>
</div>

<div id="wmsuat">
<h3 align="center" value="WMSUAT">WMSUAT</h3>
<table border='1' width='90%' align='center' summary='Script output'>
<tr><th>ORA ERROR</th><th>Timestamp</th></tr>
<tr><td>wmsaut</td><td>check</td></tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS9 STORAGE(INITIA...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS10 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS11 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS12 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS13 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS14 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS15 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS16 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS17 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS18 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS19 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS20 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS21 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS22 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS23 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS24 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS25 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []
</td>
<td>
Tue Apr 15 15:34:59 2008
</td>
</tr>
<tr>
<td>
ORA-02068: following severe error from DB_10G
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
<tr>
<td>
ORA-12571: TNS:packet writer failure
</td>
<td>
Tue May 06 15:39:35 2008
</td>
</tr>
</table>
</div>

<div id="abnapr">
<h3 align="center" value="ABNAPR">ABNAPR</h3>
<table border='1' width='90%' align='center' summary='Script output'>
<tr><th>ORA ERROR</th><th>Timestamp</th></tr>
<tr><td>ABNAPR</td><td>check</td></tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS9 STORAGE(INITIA...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS10 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS11 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS12 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS13 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS14 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS15 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS16 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS17 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS18 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS19 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS20 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS21 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS22 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS23 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS24 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-30019 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS25 STORAGE(INITI...
</td>
<td>
Wed Apr 25 20:23:11 2007
</td>
</tr>
<tr>
<td>
ORA-1119 signalled during: CREATE TABLESPACE "CPI_DATA"
</td>
<td>
Mon Apr 23 21:06:18 2007
</td>
</tr>
<tr>
<td>
ORA-1119 signalled during: CREATE TABLESPACE "CPI_DATA"
</td>
<td>
Mon Apr 23 21:26:00 2007
</td>
</tr>
<tr>
<td>
ORA-1119 signalled during: CREATE TABLESPACE "CT_CI_DETAIL_BIG"
</td>
<td>
Mon Apr 23 21:48:06 2007
</td>
</tr>
<tr>
<td>
ORA-1119 signalled during: CREATE TABLESPACE "CT_CI_DETAIL_BIG_IND"
</td>
<td>
Mon Apr 23 22:00:22 2007
</td>
</tr>
<tr>
<td>
ORA-1119 signalled during: CREATE TABLESPACE "CT_CI_DETAIL_BIG_IND"
</td>
<td>
Mon Apr 23 22:03:43 2007
</td>
</tr>
</table>
</div>

</body>
</head>
</html>
zee_no
05-09-2008, 06:45 AM
Rangana..your code is fine but i cannot use getElementbyId because my page would have tables generated dynamically when i query the database...

So i would not be able to assign ids to the tables. Hence i need to use getElementsByTagName()...

Same with switch case...i cannot use that i need to use for loop...

Many thanks for your help and efforts...Hope you can help me with the above conditions...and i hope i have not confused you....

Cheers

Zeenobia
bdl
05-09-2008, 07:04 AM
Rangana..your code is fine but i cannot use getElementbyId because my page would have tables generated dynamically when i query the database...

Err, what does the fact that they're dynamically generated have to do with anything? You still control the dynamic output. Your (PHP|ASP|JSP) script doesn't just create whatever it wants, does it?
rangana
05-09-2008, 07:06 AM
Can you give your table an ID?...That's the best way I could think of to control the display of the tables :)
zee_no
05-09-2008, 07:55 AM
no no assigning the ids to tables is not possible...no method that i could think of...but getElementsByTagName() is fine to use right????
rangana
05-09-2008, 08:37 AM
no no assigning the ids to tables is not possible...no method that i could think of...but getElementsByTagName() is fine to use right????
Yes, just fine...Try changing your script to:

<script type="text/javascript">
function get_data()
{
var x=document.getElementsByTagName("H3");
var y=document.getElementsByTagName("table");
var z=document.getElementById("chk");
var b=document.getElementById("chk").value;
switch(chk.value)
{
case 'TBSU':
reset();
x[0].style.display='';
y[1].style.display='';
break;
case 'ABNAPR':
reset();
x[4].style.display='';
y[5].style.display='';
break;
case 'CPRUDT':
reset();
x[1].style.display='';
y[2].style.display='';
break;
case 'WMSUAT':
reset();
x[3].style.display='';
y[4].style.display='';
break;
case 'JAGPROD':
reset();
x[2].style.display='';
y[3].style.display='';
break;
}
}
function reset()
{
var x=document.getElementsByTagName("H3");
var y=document.getElementsByTagName("table");
x[0].style.display='none';
x[1].style.display='none';
x[2].style.display='none';
x[3].style.display='none';
x[4].style.display='none';
y[1].style.display='none';
y[2].style.display='none';
y[3].style.display='none';
y[4].style.display='none';
y[5].style.display='none';
}
window.onload=reset;
</script>


See if it helps :)
zee_no
05-09-2008, 09:31 AM
thanks...I would finally have 84 tables on my final HTML page...therefore switch case is not practical...i think i would use switch case inside a for loop..

What do you suggest ??
rangana
05-09-2008, 09:50 AM
Possible, but I'm confused about how your tables is arranged.

Your options is arranged in this order:
TBSU
ABNAPR
CPRUDT
WMSUAT
JAGPROD

Your tables is arranged in this order:
TBSU
CPRUDT
JAGPROD
WMSUAT
ABNAPR

...arranged how your tables will be displayed and things will lighten up for you ;)
zee_no
05-09-2008, 10:04 AM
ok..so u suggest i should arrange the options in table order??

Ok but i thought that should not be a problem..

Many Thanks for all your help
rangana
05-09-2008, 10:15 AM
Yes, I would suggest to arrange it in the same order as your options because, it's as flexible as this then:

<script type="text/javascript">
function get_data()
{
var x=document.getElementsByTagName("H3");
var y=document.getElementsByTagName("table");
var z=document.getElementById("chk");
var h,b=document.getElementById("chk");
for(var i=0;i<4;i++)
{reset();x[chk.value-1].style.display='';
y[chk.value].style.display='';
}}
function reset()
{
var x=document.getElementsByTagName("H3");
var y=document.getElementsByTagName("table");
var i=0;var h=1;
for(i;i<=4;i++)
{x[i].style.display='none';}
for(h;h<=5;h++){y[h].style.display='none';}
}
window.onload=reset;
</script>

...and change your option value to numbers instead:

<option value="1">TBSU</option>
<option value="2">ABNAPR</option>
<option value="3">CPRUDT</option>
<option value="4">WMSUAT</option>
<option value="5">JAGPROD</option>


Hope makes sense :)
zee_no
05-16-2008, 07:34 AM
Hey apologies for late reply

I need to display only the headers and tables followed by it if they match the form input field.

Hence i need to add an if condition