Information Statement Problem
Edis, Bob
BEdis@usbnc.org
Thu, 26 Dec 2002 18:35:52 -0600
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C2AD3F.E8ED83E0
Content-Type: text/plain;
charset="iso-8859-1"
Dear Dianne
I'm not sure if I understand your question correctly.
Are you saying that the information statements, when executed, do not
display the values you are expecting?
I.e. when the code segment is executed you get something like:
dept code of time_att=xyz
dept code of lab_hist=
Is the code example you provide the exact syntax from the program code? If
it is then I think the problem is that the LABOUR_HISTORY record has not yet
been updated/committed so the change is still in a buffer. Try running the
program and then check the row values in a PL/SQL SELECT statement. If the
LABOUR_HISTORY row still has no value then there is a problem.
Regards,
Blue
-----Original Message-----
From: Landers, Dianne [mailto:DLanders@pcc-structurals.com]
Sent: Thursday, December 26, 2002 5:53 PM
To: Powerh-L (E-mail)
Subject: Information Statement Problem
Platform: Oracle 8.1.7, HPUX Version 11.0, PH 8.23.d7, VISIBILITY/6.36
Anyone out there experienced this problem:
LET DEPT_CODE OF LABOUR_HISTORY = DEPT_CODE OF TIME_ATTEND
info = 'dept code of time_att= ' + dept_code of time_attend now resp
info = 'dept code of lab_hist= ' + dept_code of labour_history now resp
when I try to display the value of Dept_code of labour_history it is blank.
But Dept_code of Time_attend has the correct value. if I hard code
something in the let statement, it displays. And other columns in the
Labour_History table have the correct value.
whats the deal?
Dianne Landers
PCC Structurals
------_=_NextPart_001_01C2AD3F.E8ED83E0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Information Statement Problem</TITLE>
<META content="MSHTML 5.50.4919.2200" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff size=2>Dear
Dianne</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff size=2>I'm
not sure if I understand your question correctly. </FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff size=2>Are
you saying that the information statements, when executed, do not display the
values you are expecting?</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff size=2>I.e.
when the code segment is executed you get something like:</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff size=2>dept
code of time_att=xyz</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff size=2>dept
code of lab_hist=</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff size=2>Is the
code example you provide the exact syntax from the program code? If it is
then I think the problem is that the LABOUR_HISTORY record has not yet been
updated/committed so the change is still in a buffer. Try running the
program and then check the row values in a PL/SQL SELECT statement. If the
LABOUR_HISTORY row still has no value then there is a
problem.</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>Regards,</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>Blue</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Landers, Dianne
[mailto:DLanders@pcc-structurals.com]<BR><B>Sent:</B> Thursday, December 26,
2002 5:53 PM<BR><B>To:</B> Powerh-L (E-mail)<BR><B>Subject:</B> Information
Statement Problem<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>Platform: Oracle 8.1.7, HPUX Version
11.0, PH 8.23.d7, VISIBILITY/6.36</FONT> </P>
<P><FONT face=Arial size=2>Anyone out there experienced this problem:</FONT>
</P>
<P><FONT face=Arial size=2> LET
DEPT_CODE OF LABOUR_HISTORY =
DEPT_CODE OF TIME_ATTEND</FONT> <BR><FONT face=Arial
size=2>info = 'dept code of time_att= ' + dept_code of time_attend now
resp</FONT> <BR><FONT face=Arial size=2>info = 'dept code of lab_hist= ' +
dept_code of labour_history now resp</FONT> </P>
<P><FONT face=Arial size=2>when I try to display the value of Dept_code of
labour_history it is blank. But Dept_code of Time_attend has the correct
value. if I hard code something in the let statement, it displays.
And other columns in the Labour_History table have the correct
value.</FONT></P>
<P><FONT face=Arial size=2>whats the deal?</FONT> </P>
<P><FONT face=Arial size=2>Dianne Landers</FONT> <BR><FONT face=Arial
size=2>PCC Structurals</FONT> </P></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C2AD3F.E8ED83E0--