t Stricker
703-561-3671
-Original Message-
From: Robert Durgin [mailto:rdur...@texterity.com]
Sent: Wednesday, May 02, 2012 12:19 PM
To: Stricker, Scott (IS)
Cc: dbi-users@perl.org
Subject: EXT :Re: Trying to use perl to call oracle stored proc to return an
object.
Did you specify the
All:
I'm trying to use perl to invoke a stored procedure to return an object.
Oracle Procedure is defined as
PROCEDURE FetchTrackObjbyID ( p_ID IN TRACK.ID%TYPE , p_TARGET OUT TARGET )
Where p_ID is numeric and p_TARGET is the TARGET object type.
When I 'execute', I get
DBD::Oracle::st ex
CSMDA','PASSWORD',...
and all is well.
Thanks for the help.
E. Scott Stricker
Senior Software Engineer
Northrop Grumman - Information Systems - C2SD
MailStop 4S02
2340 Dulles Corner Blvd.
Herndon, VA 20171
703-561-3671
703-713-1601 (fax)
-Original Mess
April 29, 2010 6:11 PM
To: Stricker, Scott (IS); dbi-users@perl.org
Subject: RE: Having a problem conneting to an Oracle 11gr2 RAC
It is somthing in you connection string or you do not have the
TNS_ADMIN env car set
TNS_ADMIN should point to your TNSNAMES.ORA file
> Subject: Havin
Don't know if anyone has worked with the Oracle RAC environment and
perl.
Using sqlplus, I can do the following
C:\>sqlplus ais_dbo/passw...@edc-dbserver/HCSMDA
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 29 11:55:35 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connect