Re: LONG column problem?
Re: LONG column problem?
- Subject: Re: LONG column problem?
- From: "Robert A. Decker" <email@hidden>
- Date: Mon, 20 Oct 2003 11:17:06 -0700 (PDT)
Thanks - that'll be useful. I did manage to get around this for now by
changing the internal type to String from NSData. However, changing to
LOBs is a much better solution.
thanks,
Robert A. Decker
http://www.robdecker.com/
On Mon, 20 Oct 2003, sean roehnelt wrote:
> We ran into this as well. For a quick fix look at Oracles site and they
> have some sample code to convert LONG's to LOB's.
>
> - sean
>
> On Sunday, October 19, 2003, at 07:06 PM, Art Isbell wrote:
>
> > On Sunday, October 19, 2003, at 03:54 PM, Robert A. Decker wrote:
> >
> >> We have a couple of columns in our app that are type LONG (oracle) and
> >> bound to an NSData. When I try to insert data I get the following
> >> error:
> >>
> >> Next exception:SQL State:72000 -- error code: 1461 -- msg: ORA-01461:
> >> can
> >> bind a LONG value only for insert into a LONG column
> >
> > Just a guess... It doesn't appear that Oracle is receiving what it
> > considers to be a LONG which I assume is a long integer. If it is
> > receiving an NSData, that would be binary content which might cause
> > Oracle's complaint. Have you tried setting the attribute's internal
> > data type to BigDecimal? I realize that BigInteger might seem more
> > appropriate, but I haven't seen BigInteger support in EOF.
> >
> > Aloha,
> > Art
> > _______________________________________________
> > webobjects-dev mailing list | email@hidden
> > Help/Unsubscribe/Archives:
> > http://www.lists.apple.com/mailman/listinfo/webobjects-dev
> > Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.