Re: Characters in numbers....

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