With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!
Control file ============ LOAD DATA INTO TABLE TEMP APPEND FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' ( TIME_RECIEVED FILLER, FILE_LOCATION FILLER, LOAD_DATE SYSDATE, RUN_NUMBER "schema_name.get_run_number('process_data')" ) ERROR ===== Record 1: Rejected - Error on table TEMP, column RUN_NUMBER. Column not found before end of logical record (use TRAILING NULLCOLS)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.