Trouble using overloaded pl/sql function in qtp/quick

[Deskin, Bob]

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?
 
Bob

	-----Original Message-----
	From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com [mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com] On Behalf Of Jensen, Kim Bjørn
	Sent: April 7, 2006 5:39 AM
	To: powerh-l at lists.sowder.com
	Cc: Nymoen, Helge
	Subject: Trouble using overloaded pl/sql function in qtp/quick
	
	
	Hello list
	 
	We are having trouble using overloaded pl/sql-functions from qtp and quick when the database version is Oracle 10g2.
	 
	We have been doing this troublefree when the database version was Oracle v8.1.7. 
	But now as we are (in the process of) upgrading to 10g2 we get this errormessage: "Data access error. File: ^"  
	when executing a statement like 
	"sql call <package_name>.<function_name>f (<parameterlist>)  &
	    returning <temporary to hold returning value>"
	 
	We are running PH version 843d1 on a HP9000 Unix box. 
	The Oracle client is 10.2 (I'm a not sure whether PH uses the client or an other interface). 
	 
	Any suggestions to get around this is much appreciated.
	 
	Regards
	
	Kim Bjørn Jensen
	Principal Consultant
	Lindorff AS
	E-mail: kim-bjorn.jensen at lindorff.com <blocked::mailto:kim-bjorn.jensen at lindorff.com> 
	Mailing Address: Postboks 4, NO-3833 Bø i Telemark, Norway
 
     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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060407/b8f030bb/attachment.htm