Re: Mistery INSERT satement (For Martin)

If it is not working when you do a "set role none;" before but it is working if you omit this command then you can be pretty sure that you got your access rights via a role. The setrolenone disables all roles and revokes all grants from the session.

I guess there is a coincidence in the addition of TAX_WEIGHT and an unnoticed change in your access rights.

Regards,

Martin

Kan wrote:
>
> Hi,
>
> Alone (without begin end;) is working. It is just like it is without "set
> role none;"
>
> Regards
>
> Kan
>
> Uzytkownik "Martin Haltmayer" <Martin.Haltmayer_at_d2mail.de> napisal w
> wiadomosci news:3C342621.BE4CD911_at_d2mail.de...
> > Hi Kan,
> >
> > does it work in sqlplus alone or not after the "set role none;"?
> >
> > Regards,
> >
> > Martin
> >
> >
> >
> > Kan wrote:
> > >
> > > First, Heppy New Year to all.
> > >
> > > Second, Dear Martin unfortunately I have tried but nothing, that means
> the
> > > problem steel exists. If any new idea just write.
> > >
> > > Kan
> > >
> > > Uzytkownik "Martin Haltmayer" <Martin.Haltmayer_at_d2mail.de> napisal w
> > > wiadomosci news:3C2C5DC5.CEABE1C1_at_d2mail.de...
> > > > 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 Sun Jan 06 2002 - 14:55:11 CST