You are missing the BORTTAGS_FLAGG in your INSERT STATEMENT at the end
of the code, where you are creating the string. The last variable is
vare_snr and not BORTTAGS_FLAGG
lvSQL := 'INSERT INTO PBK.PRISREGISTER(' ||
'BUTIKID,' ||
'EAN,' ||
'PERIOD,' ||
'LAGSTAPRIS,' ||
'PRIS,' ||
'UNDERLAGID,' ||
'SUBSTITUT,' ||
'KOMMENTAR,' ||
'BUTIKTYP,' ||
'VARUTYP,' ||
'REGICASTATUS,' ||
'VARENR,' ||
'LEVNR,' ||
'VARE_SNR) ' ||
'VALUES ('||
ButikID||','|| -- BUTIKID
Ean||','''|| -- EAN
Period||''', ' || -- PERIOD
LagstaPris||','|| -- LAGSTAPRIS
strButikPris ||',' || -- PRIS
inUnderlagid ||',' || -- UNDERLAGSID
strsubstitutean || ',''' || -- SUBSTITUT (null or
LPKORGEANREL.EANREL)
--''null', '|| -- KOMMENTAR
'null'', '|| -- KOMMENTAR
'0' || ' , ' || -- BUTIKTYP
--'0' || ', ' || -- BUTIKTYP
varutyp || ', ' || -- VARUTYP (0 or according to LPKORGEANREL)
IcaStatus||', ' || -- REGICASTATUS
varenr || ', ' || -- VARUNR (original VARENR, not the
substitutes)
levnr || ', ' || -- LEVNR (original LEVNR, not the substitutes)
vare_snr || ')'; -- VARE_SNR (original VARE_SNR, not the
substitutes)
--- [EMAIL PROTECTED] wrote:
> Hallo,
>
> I am trying to insert things into the table PRISREGISTER_KOPIA_WED
> but why doesnt the insert statement work.
> It says "Missing expression" when the insertstatement runs and when i
> look at the sql code which is trying to be run to insertinto the
> table
> it says just "missing expression" and it seems that I dont nclude
> BORTTAGS_FLAGG by some reason. can anyone help me with this:
> The sql which is to run is INSERT INTO
>
PBK.PRISREGISTER_kopia_wed(BUTIKID,EAN,PERIOD,LAGSTAPRIS,PRIS,UNDERLAGID,SUBSTITUT,KOMMENTAR,BUTIKTYP,VARUTYP,REGICASTATUS,VARENR,LEVNR,VARE_SNR,BORTTAGS_FLAGG)
> VALUES (116,7312300342180,'200206',
> 0,9.95,616,NULL,'null', 0 , 0, 1, 290799, 13173, 10, )
>
> As you see the last parameter is missing.
>
> The whole pl/sql code looks like this included file.
>
> (See attached file: newregicapriceroland.sql)
>
> Hope any one can help me with this. Would appreciate very much.
>
> Thanks in advance
>
> Roland S
>
>
> ATTACHMENT part 2 application/octet-stream
name=newregicapriceroland.sql
=====
Mohammed Shakir
CompuSoft, Inc.
11 Heather Way
East Brunswick, NJ 08816-2825
(732) 672-0464 (Cell)
(732) 257-6001 (Home)
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammed Shakir
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
