<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.3790.449" name=GENERATOR></HEAD>
<BODY>
<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></BODY></HTML>