Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Characters in numbers....

Re: Characters in numbers....

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Thu, 14 Sep 2006 11:58:58 GMT
Message-ID: <J5KzyI.4Es@igsrsparc2.er.usgs.gov>


devjnr_at_gmail.com wrote:
> Ora 10g.
>
> During a package I work with long numbers, making a dyn str to after an
> insert statemente using execute immediate.
>
> I encountered an error end debugging the package I noticed that a
> number values look like this:
>
> 12345678.910@1112
>
> -----> @ ???
>
> Debugging package I can say that retrieveing number value is correct.
> Have you ever see that?
>

Why are you using EXEC IMMEDIATE with an INSERT statement? Why not just perform the INSERT without EXEC IMMEDIATE? Is your variable defined as NUMBER or VARCHAR2?

You posted no code, so we can only guess as to why yo have non-numbers in your value.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
Received on Thu Sep 14 2006 - 06:58:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US