oracle - SQL Loader : Not enough values -

-

need debugging. table structure below :

respond_by_date                timestamp(6)   , description                    varchar2(300)  , axbcrule               number(4)      not null, segment                        varchar2(100)  , assign_unique_balcon           varchar2(1)    , balcon_offer_type              varchar2(3)    , apr                            varchar2(10)   , fee_yn                         varchar2(1)    , fee_percent                    varchar2(10)   , fee_amount_max                 varchar2(10)   , balcon_duration_type           varchar2(7)    , balcon_duration                varchar2(3)    , balcon_cap_amount              varchar2(10)   , interim_apr                    varchar2(10)   , interim_duration_type          varchar2(7)    , interim_duration               number(3)      , balcon_id                      number(7)      , channel_id              varchar2(7)   not null , subchannel_id           varchar2(7)   not null , program_name            varchar2(45)   not null, date_initiated          timestamp(6)   not null, error_message                  varchar2(1024) , status                         number(2)      , user_code                      varchar2(10)   , warning_message                varchar2(1024) , balcon_offer_sequence   number(2)      not null, campaign_tag                   varchar2(3)

it has total of 27fields , used below ctl file load it:

options (load=1) load data          infile *     replace table test_table       (respond_by_date        sysdate, description            constant   'test',           axbcrule               constant   '011',         segment                constant   '12',          assign_unique_balcon   constant   '1',           balcon_offer_type      constant   '1',           apr                    constant   '12',          fee_yn                 constant   'y',           fee_percent            constant   '009',         fee_amount_max         constant   '12',           balcon_duration_type   constant   '1',           balcon_duration        constant   '12',          balcon_cap_amount      constant   '0123',        interim_apr            constant   '1',          interim_duration_type  constant   'n',           interim_duration       constant   '1',           balcon_id              constant   '1',           channel_id       constant '1',           subchannel_id          constant   '1',           program_name           constant   '1',           date_initiated         sysdate,           error_message          constant   '1',           status                 constant   '1' ,          user_code              constant   '1',           warning_message        constant   '1',           balcon_offer_sequence  constant   '1', campaign_tag constant   '1' )

when try load test data table, facing below error :

record 1: rejected - error on table "schema"."test_table".  ora-00947: not enough values

kindly me out. in advance.

change control file entries timestamp columns like:

respond_by_date expression "cast(sysdate timestamp)"

a date , timestamp not same datatypes. need convert sysdate timestamp.

ora-00947 being raised when process tries put sysdate timestamp. sysdate not have same fractional seconds component timestamp requires.


Comments

Post a Comment

Popular posts from this blog

python - mat is not a numerical tuple : openCV error -

-
i have write down code showing error ma not getting it: please help: showing mat not numerical tuple: import cv import cv2 capture = cv2.videocapture("j.3gp") while(1): _, frame1 = capture.read() grayimage1 = cv2.cvtcolor(frame1, cv2.color_bgr2gray) _, frame2 = capture.read() grayimage2 = cv2.cvtcolor(frame2, cv2.color_bgr2gray) differenceimage = cv2.absdiff(grayimage1,grayimage2) thresholdimage = cv2.threshold(differenceimage,25,255,cv2.thresh_binary) cv2.imshow("difference image", differenceimage) cv2.imshow("threshold image", thresholdimage) cv2.imshow("image", frame1) k = cv2.waitkey(30) & 0xff error arising : ----------------------------------------------------------------------------------------- traceback (most recent call last): file "desk.py", line 15, in <module> cv2.imshow("threshold image", thresholdimage) typeerror: mat not numerical tuple ...
Read more

c# - MSAA finds controls UI Automation doesn't -

-
i'm working on automating windows application. i'm using teststack white framework. i've hit problem. program has 'window' object cannot see inside of. white shows no controls inside of it. inspect.exe shows no controls inside of either when running in ui automation mode. if switch inspect msaa see controls inside fine. there anyway me use msaa c# handle on these controls? if can identify msaa functions need, can use p/invoke call them c#. here's example article doing msaa: http://www.codeproject.com/articles/38906/ui-automation-using-microsoft-active-accessibility also, pinvoke.net can used identify iaccessible (msaa) functions: http://www.pinvoke.net/search.aspx?search=iaccessible&namespace=[all] here's answer along lines: msaa com-based? finally, alternative p/invoke, might able use tlbimp.exe create wrapper assembly oleacc.dll, , access msaa functions through it. i'm not sure if works msaa, it's worth try. as e...
Read more

wordpress - .htaccess: RewriteRule: bad flag delimiters -

-
pulling hair out on one. have following .htaccess file custom redirects in addition wordpress's default settings. when tested on local wamp server worked fine after moving production i'm not getting rewriterule: bad flag delimiters error in server log , after while site goes down internal server error any appreciated. in advance! <ifmodule mod_rewrite.c> rewriteengine on rewritebase / rewriterule ^rockford_weddings___welcome\.html$ /wedding/ [r=301,l] rewriterule ^blog/?$ /journal/ [r=301,l] rewriterule ^blog/(.*)$ /$1 [r=301,l] rewriterule ^portraitinvestment/?$ /portraitinvestment\.pdf [r=301,l] rewriterule ^weddinginvestment/?$ /weddinginvestment\.pdf [r=301,l] rewriterule ^holidaycards2014/?$ /holidaycards2014\.pdf [r=301,l] </ifmodule> # begin wordpress <ifmodule mod_rewrite.c> rewriteengine on rewritebase / rewriterule ^index\.php$ - [l] rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewriterule . /index.php [l] </...
Read more