Re: Mistery INSERT satement

Hi Kan,

is it still working if you do in sqlplus

set role none;
INSERT INTO CONTROL.T_WAGGONS (WAGGON_ID, AVISO_ID, OFFERT_WAG_ID, WAGGON_NR, REAL_WEIGHT, NHM, DATE_DISP, CLIENT_OFFERT_WAG_ID, OFF_CLIENT_OFFERT_ID, RELATION_ID, WAGGON_NR2, ADD_COSTS, DOSIER_ID, ADD_CURR, ADD_DESC, NOTE, WAG_TYPE, OFFERT_NOTE, ANNEX_ID, UPDATE_DATE, TRAIN_NR, INCOME_DATE, TAX_WEIGHT) VALUES (TO_NUMBER('100010031939'),TO_NUMBER('100010001862'),TO_NUMBER('200000021597 '),'318127712905',TO_NUMBER('20,764'),'4803',TO_DATE('04/12/2001','dd/mm/yyy y'),'200000015198',TO_NUMBER('200000013369'),TO_NUMBER('200000010248'),NULL, TO_NUMBER('63,6'),TO_NUMBER('100010001172'),1,NULL,NULL,NULL,NULL,TO_NUMBER( '0'),NULL,NULL,NULL,TO_NUMBER('0')); Please try.

Regards,

Martin

Kan wrote:
>
> OK Martin here it is.
>
> DECLARE
> K NUMBER;
> BEGIN
> EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '', ''';
> INSERT INTO CONTROL.T_WAGGONS (WAGGON_ID, AVISO_ID, OFFERT_WAG_ID,
> WAGGON_NR, REAL_WEIGHT, NHM, DATE_DISP, CLIENT_OFFERT_WAG_ID,
> OFF_CLIENT_OFFERT_ID, RELATION_ID, WAGGON_NR2, ADD_COSTS, DOSIER_ID,
> ADD_CURR, ADD_DESC, NOTE, WAG_TYPE, OFFERT_NOTE, ANNEX_ID, UPDATE_DATE,
> TRAIN_NR, INCOME_DATE, TAX_WEIGHT) VALUES
> (TO_NUMBER('100010031939'),TO_NUMBER('100010001862'),TO_NUMBER('200000021597
> '),'318127712905',TO_NUMBER('20,764'),'4803',TO_DATE('04/12/2001','dd/mm/yyy
> y'),'200000015198',TO_NUMBER('200000013369'),TO_NUMBER('200000010248'),NULL,
> TO_NUMBER('63,6'),TO_NUMBER('100010001172'),1,NULL,NULL,NULL,NULL,TO_NUMBER(
> '0'),NULL,NULL,NULL,TO_NUMBER('0'));
> k := control.F_Update_Wag_Cost(100010031939);
> end;
>
> ORA-06550: line 4, column 295:
> PLS-00390: undefined column 'TAX_WEIGHT' in INSERT statement.
>
> If you copy (CTRL+C) only insert statement and run it it is working. I have
> this problem for one month, from the time I introduce field TAX_WEIGHT and I
> have tried it lot of times and the problem is same.
>
> I think I now where the problem is. I have UTF8 characterset on the database
> where this problem comes out (oh yes I forget to tel that this problem
> apears not on all databases) so it cold be problem with characterset. As far
> as I now there a lot of problems with UTF8 in 8.1.7 version (I am working
> with XMLs and I have lot of problems).
>
> I you have some idea what could it be I will be glad to hear it.
>
> Regards
> Kan.
>
> Uzytkownik "Martin Haltmayer" <Martin.Haltmayer_at_d2mail.de> napisal w
> wiadomosci news:3C2C472C.C5CA70A5_at_d2mail.de...
> > Hi Kan,
> >
> > can you please show the structure of TAB1 and the full statements without
> dots
> > and the respective error message? I do not believe that your description
> is
> > complete and correct.
> >
> > Regards,
> >
> > Martin
> >
> >
> >
> > Kan wrote:
> > >
> > > Hi all,
> > >
> > > I have very strange situation and wondering if somebody have something
> like
> > > this earlier.
> > > If I run next statement
> > >
> > > INSERT INTO TAB1 (COL1, COL2, .., COLN) VALUES (VAL1, VAL2, .., VAL3)
> > >
> > > everything is OK, But if I run the same statement like this
> > >
> > > BEGIN
> > > INSERT INTO TAB1 (COL1, COL2, .., COLN) VALUES (VAL1, VAL2, .., VAL3);
> > > END;
> > >
> > > I got next error:
> > >
> > > PLS-0039: undefined column 'COLN' in INSERT statement.
> > >
> > > Note: N = 23.
> > >
> > > Does anybody had something like this befor?
> > >
> > > Thanks to all
Received on Fri Dec 28 2001 - 05:55:49 CST