 
 create table temp_all_barcode as select barcode from container where barcode is not null;
 
+UAM@ARCTOS> select count(*) from temp_all_barcode;
+
+  COUNT(*)
+----------
+   2830633
+
 
 CREATE OR REPLACE PROCEDURE temp_update_junk IS
 	rslt varchar2(255):='FAIL';

			</ul>
		</p>

		<cfparam name="barcode" default="">
		<form name="t" method="get" action="barcodeseries.cfm">
			<label for="barcode">Enter a barcode to test</label>
			<input type="text" value="#barcode#" name="barcode">
			<input type="submit" value="test this barcode">
		</form>
		<cfquery name="d" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
			select * from cf_barcodeseries order by barcodeseriestxt
		</cfquery>

	end;
/
sho err;


BEGIN
  DBMS_SCHEDULER.CREATE_JOB (
    job_name    => 'J_temp_update_junk',
    job_type    => 'STORED_PROCEDURE',
    job_action    => 'temp_update_junk',
    enabled     => TRUE,
    end_date    => NULL
  );
END;
/

select STATE,LAST_START_DATE,NEXT_RUN_DATE from all_scheduler_jobs where JOB_NAME='J_TEMP_UPDATE_JUNK';


exec temp_update_junk;

