• Welcome to KonaKart Community Forum. Please login or sign up.
 
August 21, 2025, 05:42:54 am

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - p.cornelissen

1
Worked like a charm!

Thanks Heidi
2
Thanks Heidi!
I'll try that tomorrow, when I'm back at work.
3
Hi!

I am experiencing the same problem. Deployment on jboss 4.2 works, but 5.0.x throws the errors mentioned in the first post.
Is there a solution yet?
4
Hi!

Quote from: jerolimov on February 11, 2009, 01:06:15 pm
...
In both lines the single quote (') around the value colum (around 1.0000 and 1.1036) must be removed.

Instead of:
INSERT INTO currencies VALUES (currencies_seq.nextval,'US Dollar','USD','$','','.',',','2','1.0000', sysdate);
INSERT INTO currencies VALUES (currencies_seq.nextval,'Euro','EUR','','EUR','.',',','2','1.1036', sysdate);

It must be:
INSERT INTO currencies VALUES (currencies_seq.nextval,'US Dollar','USD','$','','.',',','2',1.0000, sysdate);
INSERT INTO currencies VALUES (currencies_seq.nextval,'Euro','EUR','','EUR','.',',','2',1.1036, sysdate);


I'd suggest to use the to_number function, so you can provide the number and the number format, so you won't get into trouble with different NLS settings.