<HTML >
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY >
<DIV>
<DIV><SPAN class=222203915-07042006><FONT face=Arial color=#0000ff size=2>Have
you changed the PowerHouse version? This may be due to things being more
restrictive (SQL 92 compatibility) in the current version of PowerHouse. It also
may be due to changes in the gateway. Have you contacted customer
support?</FONT></SPAN></DIV>
<DIV><SPAN class=222203915-07042006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=222203915-07042006><FONT face=Arial color=#0000ff
size=2>Bob</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com] <B>On Behalf
Of </B>Jensen, Kim Bjørn<BR><B>Sent:</B> April 7, 2006 5:39 AM<BR><B>To:</B>
powerh-l@lists.sowder.com<BR><B>Cc:</B> Nymoen, Helge<BR><B>Subject:</B>
Trouble using overloaded pl/sql function in qtp/quick<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=809052109-07042006>Hello
list</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=809052109-07042006><FONT face=Arial size=2>We are having
trouble using overloaded pl/sql-functions from qtp and quick when the
database version is Oracle 10g2.</FONT></SPAN></DIV>
<DIV><SPAN class=809052109-07042006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=809052109-07042006><FONT face=Arial size=2>We have been doing
this troublefree when the database version was Oracle v8.1.7.
</FONT></SPAN></DIV>
<DIV><SPAN class=809052109-07042006><FONT face=Arial size=2>But now as we are
(in the process of) upgrading to 10g2 we get this errormessage: "<FONT
size=2>Data access error. File: ^</FONT>" </FONT></SPAN></DIV>
<DIV><SPAN class=809052109-07042006><FONT face=Arial size=2>when executing a
statement like </FONT></SPAN></DIV>
<DIV><SPAN class=809052109-07042006><FONT face=Arial size=2>"sql call
<package_name>.<function_name>f (<parameterlist>)
&<BR> returning <temporary to hold returning
value>"</FONT></SPAN></DIV>
<DIV><SPAN class=809052109-07042006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=809052109-07042006><FONT face=Arial size=2>We are running PH
version 843d1 on a HP9000 Unix box. </FONT></SPAN></DIV>
<DIV><SPAN class=809052109-07042006><FONT face=Arial size=2>The Oracle client
is 10.2 (I'm a not sure whether PH uses the client or an other
interface). </FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=809052109-07042006>Any suggestions to
get around this is much appreciated.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=809052109-07042006><FONT face=Arial
size=2>Regards</FONT></SPAN></DIV>
<DIV align=left>
<DIV align=left>
<DIV align=left><FONT face=Arial size=2>
<DIV align=left>
<DIV align=left>
<DIV align=left><FONT face=Arial size=2><EM>Kim Bjørn Jensen</EM></FONT></DIV>
<DIV><FONT face=Arial size=2><EM>Principal Consultant</EM></FONT></DIV>
<DIV><FONT face=Arial size=2><EM>Lindorff AS</EM></FONT></DIV>
<DIV><FONT face=Arial size=2><EM>E-mail: </EM></FONT><A
title=mailto:kim-bjorn.jensen@lindorff.com
href="blocked::mailto:kim-bjorn.jensen@lindorff.com"><FONT
title=mailto:kim-bjorn.jensen@lindorff.com face=Arial
size=2><EM>kim-bjorn.jensen@lindorff.com</EM></FONT></A></DIV>
<DIV><FONT face=Arial size=2><EM>Mailing Address: Postboks 4, NO-3833 Bø i
Telemark, Norway</EM></FONT></DIV></DIV>
<DIV> </DIV></DIV></FONT></DIV></DIV></DIV></BLOCKQUOTE></DIV>
<DIV> </DIV>
<DIV> This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you. </DIV></BODY></HTML>