doktorZee wrote:
Salutations all, I'm working on a Perl script to migrate data through
ODBC from a series of tables on one DBMS to a single table on a
separate DBMS, with access connections defined in the ODBC Sources
Win32 control panel applet.
It works fine on my computer and a co-worker's
Well maybe DBD::Oracle dose not know how to bind them,
Set the debug to 15 before the prepare statement and off after the binds
and lets see what you get.
these are very obscure Oracle types so I could see that they may not work.
cheers
John Scoles
Vanole, Mike wrote:
Thanks Joseph,
I
On Feb 12, 2008 3:26 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
attempting a DB connection using a brand new installation of perl
5.8.8 on an old sun box: 'sun4u sparc SUNW,Ultra-4'.
i have connectivity.
this command line script returns a reference to a hash:
perl -MDBI -e 'print DBI-
hi,
attempting a DB connection using a brand new installation of perl
5.8.8 on an old sun box: 'sun4u sparc SUNW,Ultra-4'.
i have connectivity.
this command line script returns a reference to a hash:
perl -MDBI -e 'print DBI-
connect(DBI:Sybase:server=,user,password)'
but when i attempt to
That worked. I formatted the input as executed as described and
everything loaded.
Thank you, Ian.
Hopefully, all this will serve my need in the end. I'm actually trying
to come up with a way to overcome the lack of a TIME with TIME ZONE
datatype as part of a conversion from PostgreSQL to
Sorry, I haven't tried anything to test what I am about to recommend. It
doesn't look like you got your answer though. I think you want your insert
statement to look like this:
$db-do(EOS,{},1,'0 03:00:00')
insert into batch_application_sla (job_id, job_duration)
Thanks Joseph,
I chickened out and built the full insert statement I knew would run and
ran it in a do().
I will goof around with bind_param, but I would love to know how to do
this with '?' style placeholders. There's got to be a syntax that works
- that will load INTERVAL DAY to SECOND
Mike
This may be less a DBI question and more Oracle - probably both...
Using DBD::Oracle
Given this table:
TABLE batch_application_sla
Name Null?Type
-
ASSOCIATION
Hello,
I am getting a warning like
DBD::Oracle::st fetchrow_hashref warning: (err=0, errstr=undef,
state=undef) [for Statement
SELECT item.nreference, item.chold, item.npieces,
item.nweight,
item.ncube, item.cshippername,
item.cwarehouselocation,
Mike,
Here are some of the things that I would do.
1. Set the NLS Date Format
Example I pulled from the internet
# set Oracle NLS date format
if ( $optctl{dateformat} ) {
$dbh-do(qq{alter session set nls_date_format
= '$optctl{dateformat}'} );
}
2. Using bind_param set all your
10 matches
Mail list logo