Trying to use perl to call oracle stored proc to return an object.

2012-05-02 Thread Stricker, Scott (IS)
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

RE: EXT :Re: Trying to use perl to call oracle stored proc to return an object.

2012-05-02 Thread Stricker, Scott (IS)
: 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 direction for each parameter? - Original Message

RE: Having a problem conneting to an Oracle 11gr2 RAC

2010-04-30 Thread Stricker, Scott (IS)
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: Having a problem conneting

RE: Having a problem conneting to an Oracle 11gr2 RAC

2010-04-30 Thread Stricker, Scott (IS)
. 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 Message- From: Stricker, Scott (IS) [mailto:scott.stric...@ngc.com] Sent

Having a problem conneting to an Oracle 11gr2 RAC

2010-04-29 Thread Stricker, Scott (IS)
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.

RE: unable to write from a select into outfile

2009-05-15 Thread Stricker, Scott E (IS)
All: I'm running on a windows XP box with latest MS updates, ActiveState perl (v5.10.0 built for MSWin32-x86-multi-thread) DBI (1.607) DBD-ODBC (1.21) SQL Server 2005 (SP3) Seems like all of a sudden queries against my database are not returning the correct data. First noticed when executing a

RE: unable to write from a select into outfile

2009-05-15 Thread Stricker, Scott E (IS)
] Sent: Friday, May 15, 2009 1:02 PM To: Stricker, Scott E (IS) Cc: dbi-users@perl.org Subject: Re: unable to write from a select into outfile -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stricker, Scott E (IS) wrote: All: I'm running on a windows XP box with latest MS updates, ActiveState