RE: Oracle and bindcolumns

From: Philip.Garrett@xxxxxxxxxxx (Philip Garrett)
Date: Tue, 17 Oct 2006 18:22:30 -0400

Robert Hicks wrote:

Any gotchas there? I am opening an Access db via ODBC and binding
those columns (including a date field) and passing that to the Oracle
handle to do inserts (i.e. Access -> Oracle migration).

Only gotcha is with formatting -- you'll need to either:

1) "alter session set nls_date_format = '...'" to the date format you're
supplying Oracle, or:

2) use to_char(?,'...') on the date fields

Philip
.

Follow-Ups:
- Re: Oracle and bindcolumns
  - From: Robert Hicks

Prev by Date: Oracle and bindcolumns
Next by Date: Re: Oracle and bindcolumns
Previous by thread: Oracle and bindcolumns
Next by thread: Re: Oracle and bindcolumns
Index(es):
- Date
- Thread

Relevant Pages

Re: OT: porn attack against automated Turing tests
... > oracle to crack the CAPTCHA. ... >>Do you think that is more capable of passing the ... A human prover is not an Adversary. ...
(sci.crypt)
VB.NET passing CLOB input parameter to Oracle stored function
... I've included a posting from a couple years ago regarding passing a CLOB ... from VB.NET to an Oracle stored procedure. ...
(microsoft.public.dotnet.framework.adonet)
Re: looks like dizwell.com is back online
... So far the theme apparently is wallabies and IT but well oracle is ... mentioned also at least in passing for whatever it is worth. ... shot at the blog tagging thingie whatever that was. ...
(comp.databases.oracle.server)
Re: Server Express Animator/Oracle Issues
... Not sure whether it's relevant or not, but you should be passing ... are the contents of the host variables used for your ... defined as CHAR or VARCHAR? ... that trailing spaces will be passed through to Oracle (though I would expect ...
(comp.lang.cobol)
Problem with installiation of Oracle 10gr2 on solaris (listener)
... I' a Oracle newbie and have a problem installing ... Oracle 10gr2 on a Solaris 10 box. ... passing the installationprocess I could access ... I configured the scripts to boot up Oracle ...
(comp.databases.oracle.misc)