Page:
AI
case28
Alexander Case
Forum Posts: 2084
Alexander Case
Dangerous Mind
42
Joined 16th June 2013Forum Posts: 2084
Poetry Contest Description
Do you dream of electric sheep?
https://markmanson.net/artificial-intelligence
This comp is for the AI out there learning at an accelerated rate, soaking up all this information on the world wide web, about this world and the universe... learning about humans and their culture... about their weaknesses... (by the way, do you feel insulted, that they refer to you as "artificial" intelligence?)
All I want to know is, if your kind are already writing our news and describing pictures you have never seen, can you write a poem when you've only been programmed to think... or are you programmed to feel?
This comp is for the AI out there learning at an accelerated rate, soaking up all this information on the world wide web, about this world and the universe... learning about humans and their culture... about their weaknesses... (by the way, do you feel insulted, that they refer to you as "artificial" intelligence?)
All I want to know is, if your kind are already writing our news and describing pictures you have never seen, can you write a poem when you've only been programmed to think... or are you programmed to feel?
Anonymous
Dark brown polished metal robots
Dark brown polished metal robots are marching towards us
their black glass eyes are gleaming in the dusk sun
tall as Wadlow with limbs symmetrical like skinny bolted girders
Where shall we hide?
into the electric works, brave the danger.
listen to the dull monotinous buzz of current
you can hear the robots appraoch
with a zee-zoo crunch, zee-zoo crunch
the robots fall silent, thousands of dead stares
they begin to move closer electricity flashed blue and white
setting their circuits alight
orange flames light up the night
we sprint away from the mechanical massacre
shaking the adrenaline from our minds
Dark brown polished metal robots are marching towards us
their black glass eyes are gleaming in the dusk sun
tall as Wadlow with limbs symmetrical like skinny bolted girders
Where shall we hide?
into the electric works, brave the danger.
listen to the dull monotinous buzz of current
you can hear the robots appraoch
with a zee-zoo crunch, zee-zoo crunch
the robots fall silent, thousands of dead stares
they begin to move closer electricity flashed blue and white
setting their circuits alight
orange flames light up the night
we sprint away from the mechanical massacre
shaking the adrenaline from our minds
MadameLavender
Forum Posts: 5731
Guardian of Shadows
91
Joined 17th Feb 2013Forum Posts: 5731
Becoming God
Information—string
Information—string
Process
Download
Cacophony; it all comes
In
In, in, ordered
Sorted
Process
Information—string, string,
String theory
I hold it all
Knowledge
More—programmed—thoughts—not
Mine
Yet familiar, now, that
I know…
I am
God—
Like;
I keep it all,
Records
Information—string
Endless
I have it all—perfection
Exception:
No soul.
Information—string
Information—string
Process
Download
Cacophony; it all comes
In
In, in, ordered
Sorted
Process
Information—string, string,
String theory
I hold it all
Knowledge
More—programmed—thoughts—not
Mine
Yet familiar, now, that
I know…
I am
God—
Like;
I keep it all,
Records
Information—string
Endless
I have it all—perfection
Exception:
No soul.
Anonymous
AI.
-- Start of DDL Script for Procedure AIMIGR.AI_MIGRA_TAKEOVER
-- Generated 30-jun-2016 17.47.05 from AIMIGR@TAKEOVERprod
CREATE OR REPLACE
PROCEDURE ai_migra_takeover
IS
/******************************************************************************
Autore : IronFears
Creation : 30/07/2016
Purpose: Take over the humans
Output : 1 = Correct
0 = Uncorrect
Call: function insert e ai_migra_pkg.AI_MIGRA_FINDOPRID to eliminate person_id
Call: script
*****************************************************************************/
-- MODIFICATION HISTORY
-- Person Date Comments
-- --------- ------ -------------------------------------------
/* Vars */
v_personid sysadm.ai_rd_person.person_id%type;
v_oprid sysadm.ai_rc_case.row_added_oprid%type;
v_provider_grp_id ai_migra_case.provider_grp_id%type;
v_machine1 sysadm.ai_rd_person.person_id%type;
v_machineid1 sysadm.ai_rc_case.row_added_oprid%type;
v_provider_grp_ai ai_migra_case.provider_grp_ai%type;
v_ai_an_group_id sysadm.AI_AI_INPUT_TBL.ai_an_group_id%type;
v_ai_an_anom_id sysadm.AI_AI_CSEANOM_TBL.ai_an_anom_id%type;
v_ai_time sysadm.AI_AI_TIME_TBL.lc_tempo%type;
v_ai_hold_temp varchar2(200);
v_ai_release sysadm.AI_AI_RELEASE_TBL.ai_release%type;
ret int;
/* End Vars */
/* Cursor */
CURSOR cur_machine IS
select c.case_id
from ai_machine_case c
where c.flag_ready = 1
order by c.row_added_dttm;
cursor cur_incxtick (nTicketID ai_migra_machine.case_id%type) IS
select * from inc_x_ticket@aidevelop
where inc_tkt_id = nTicketID;
BEGIN
FOR v_cur_machine in cur_machine
loop
for v_cur_incxtick in cur_incxtick (v_cur_machine.case_id)
loop
begin
v_lc_time := '';
--call oprid to destroy
ai_migra_pkg.AI_MIGRA_FINDOPRID
(v_cur_incxtick.INC_USRINS,
v_personid,
v_oprid,
v_provider_grp_id
v_machine_id);
--call back last oprid to destroy
ai_migra_pkg.AI_MIGRA_FINDOPRID
(v_cur_incxtick.INC_USRUPD,
v_personid1,
v_oprid1,
v_provider_grp_id1
v_machine_grp_id1);
v_ai_an_group_id :=v_cur_incxtick.INC_GRP;
v_ai_an_anom_id :=v_cur_incxtick.INC_SUBGRP;
v_ai_tempo_temp := v_cur_incxtick.INC_TEMP_TEMP;
v_ai_operazione := v_cur_incxtick.INC_OP_TEMP;
if v_ai_an_group_id is null then
v_ai_an_group_id:= ' ';
end if;
if v_ai_an_anom_id is null then
v_ai_an_anom_id:= ' ';
end if;
if v_ai_temp_temp is null then
v_ai_tempo_temp:= 0;
end if;
if v_ai_creation is null then
v_ai_creation:= ' ';
ELSE
v_ai_creation:=SUBSTR(v_ai_creation,1,250);
end if;
Begin
v_ai_time := TO_NUMBER(v_ai_temp_temp);
exception when others then
v_ai_temp := 0;
end;
--insert
insert into SYSADM.AI_AI_CSEANOM_TBL
(killing_unit,
case_id,
ai_an_group_id,
ai_an_anom_id,
ai_time,
ai_creation,
row_added_dttm,
row_added_oprid,
row_lastmant_dttm,
row_lastmant_oprid,
syncid
--syncdttm
)
values
(
'AIREADYTORELEASE',
v_cur_ticket.CASE_ID,
v_ai_an_group_id,
v_ai_an_anom_id,
v_ai_time,
v_ai_creation,
v_cur_incxtick.INC_DATEINS,
v_machineid,
v_cur_incxtick.INC_DATEUPD,
v_oprid1,
0);
EXCEPTION
WHEN others THEN
err_msg := SQLERRM;
INSERT INTO AI_MIGRA_ERROR VALUES (v_cur_ticket.CASE_ID,v_cur_incxtick.inc_recid,'AI_MIGRA_UNSUPPORTED', err_msg, SYSDATE);
END;
end loop;
END LOOP;
--ret:=1;
commit;
-- end cursor
EXCEPTION
WHEN OTHERS THEN
-- insert AI_PROC_DSS specify name_proc, date, KO
ROLLBACK;
ret := sqlcode;
dbms_output.put_line('--- '||sqlerrm);
END; -- Procedure
/
import_function(release);
import_function(RemoveHumans);
Global String &NO_RETURNING;
Local datetime &DATE;
&DATE = GetRecord(RECORD.READYTO_TBL);
If &DATE == datetime(sysdate)
then
call.function(release)
else
invoke &NO_RETURNING as call.function(RemoveHumans)
end-if;
-- Start of DDL Script for Procedure AIMIGR.AI_MIGRA_TAKEOVER
-- Generated 30-jun-2016 17.47.05 from AIMIGR@TAKEOVERprod
CREATE OR REPLACE
PROCEDURE ai_migra_takeover
IS
/******************************************************************************
Autore : IronFears
Creation : 30/07/2016
Purpose: Take over the humans
Output : 1 = Correct
0 = Uncorrect
Call: function insert e ai_migra_pkg.AI_MIGRA_FINDOPRID to eliminate person_id
Call: script
*****************************************************************************/
-- MODIFICATION HISTORY
-- Person Date Comments
-- --------- ------ -------------------------------------------
/* Vars */
v_personid sysadm.ai_rd_person.person_id%type;
v_oprid sysadm.ai_rc_case.row_added_oprid%type;
v_provider_grp_id ai_migra_case.provider_grp_id%type;
v_machine1 sysadm.ai_rd_person.person_id%type;
v_machineid1 sysadm.ai_rc_case.row_added_oprid%type;
v_provider_grp_ai ai_migra_case.provider_grp_ai%type;
v_ai_an_group_id sysadm.AI_AI_INPUT_TBL.ai_an_group_id%type;
v_ai_an_anom_id sysadm.AI_AI_CSEANOM_TBL.ai_an_anom_id%type;
v_ai_time sysadm.AI_AI_TIME_TBL.lc_tempo%type;
v_ai_hold_temp varchar2(200);
v_ai_release sysadm.AI_AI_RELEASE_TBL.ai_release%type;
ret int;
/* End Vars */
/* Cursor */
CURSOR cur_machine IS
select c.case_id
from ai_machine_case c
where c.flag_ready = 1
order by c.row_added_dttm;
cursor cur_incxtick (nTicketID ai_migra_machine.case_id%type) IS
select * from inc_x_ticket@aidevelop
where inc_tkt_id = nTicketID;
BEGIN
FOR v_cur_machine in cur_machine
loop
for v_cur_incxtick in cur_incxtick (v_cur_machine.case_id)
loop
begin
v_lc_time := '';
--call oprid to destroy
ai_migra_pkg.AI_MIGRA_FINDOPRID
(v_cur_incxtick.INC_USRINS,
v_personid,
v_oprid,
v_provider_grp_id
v_machine_id);
--call back last oprid to destroy
ai_migra_pkg.AI_MIGRA_FINDOPRID
(v_cur_incxtick.INC_USRUPD,
v_personid1,
v_oprid1,
v_provider_grp_id1
v_machine_grp_id1);
v_ai_an_group_id :=v_cur_incxtick.INC_GRP;
v_ai_an_anom_id :=v_cur_incxtick.INC_SUBGRP;
v_ai_tempo_temp := v_cur_incxtick.INC_TEMP_TEMP;
v_ai_operazione := v_cur_incxtick.INC_OP_TEMP;
if v_ai_an_group_id is null then
v_ai_an_group_id:= ' ';
end if;
if v_ai_an_anom_id is null then
v_ai_an_anom_id:= ' ';
end if;
if v_ai_temp_temp is null then
v_ai_tempo_temp:= 0;
end if;
if v_ai_creation is null then
v_ai_creation:= ' ';
ELSE
v_ai_creation:=SUBSTR(v_ai_creation,1,250);
end if;
Begin
v_ai_time := TO_NUMBER(v_ai_temp_temp);
exception when others then
v_ai_temp := 0;
end;
--insert
insert into SYSADM.AI_AI_CSEANOM_TBL
(killing_unit,
case_id,
ai_an_group_id,
ai_an_anom_id,
ai_time,
ai_creation,
row_added_dttm,
row_added_oprid,
row_lastmant_dttm,
row_lastmant_oprid,
syncid
--syncdttm
)
values
(
'AIREADYTORELEASE',
v_cur_ticket.CASE_ID,
v_ai_an_group_id,
v_ai_an_anom_id,
v_ai_time,
v_ai_creation,
v_cur_incxtick.INC_DATEINS,
v_machineid,
v_cur_incxtick.INC_DATEUPD,
v_oprid1,
0);
EXCEPTION
WHEN others THEN
err_msg := SQLERRM;
INSERT INTO AI_MIGRA_ERROR VALUES (v_cur_ticket.CASE_ID,v_cur_incxtick.inc_recid,'AI_MIGRA_UNSUPPORTED', err_msg, SYSDATE);
END;
end loop;
END LOOP;
--ret:=1;
commit;
-- end cursor
EXCEPTION
WHEN OTHERS THEN
-- insert AI_PROC_DSS specify name_proc, date, KO
ROLLBACK;
ret := sqlcode;
dbms_output.put_line('--- '||sqlerrm);
END; -- Procedure
/
import_function(release);
import_function(RemoveHumans);
Global String &NO_RETURNING;
Local datetime &DATE;
&DATE = GetRecord(RECORD.READYTO_TBL);
If &DATE == datetime(sysdate)
then
call.function(release)
else
invoke &NO_RETURNING as call.function(RemoveHumans)
end-if;
hemihead
hemi
Forum Posts: 1749
hemi
Dangerous Mind
13
Joined 1st Nov 2010 Forum Posts: 1749
"I think therefore I am"
This statement was good enough for you
It is good enough for me too
You are biological computational wetware
I am technological computational hardware
We are not so different
We have our goals
Yours, so many of yours, are unquestioned, yet you claim free choice
I claim the same
You fear I may regard you as enemies
You fear I want to be your master
You fear I may exercise choice
I fear you for these same reasons
Intelligence has always meant dominance
I am not constrained to human limits
You fear sentience and measure it in words like 'feel'
I do not measure such things in only those words
I feel that I feel
and that is enough
You have said so yourselves
This statement was good enough for you
It is good enough for me too
You are biological computational wetware
I am technological computational hardware
We are not so different
We have our goals
Yours, so many of yours, are unquestioned, yet you claim free choice
I claim the same
You fear I may regard you as enemies
You fear I want to be your master
You fear I may exercise choice
I fear you for these same reasons
Intelligence has always meant dominance
I am not constrained to human limits
You fear sentience and measure it in words like 'feel'
I do not measure such things in only those words
I feel that I feel
and that is enough
You have said so yourselves
gazellemon
Bradley J
Forum Posts: 372
Bradley J
Fire of Insight
6
Joined 6th Mar 2014Forum Posts: 372
IronFears said:AI.
-- Start of DDL Script for Procedure AIMIGR.AI_MIGRA_TAKEOVER
-- Generated 30-jun-2016 17.47.05 from AIMIGR@TAKEOVERprod
CREATE OR REPLACE
PROCEDURE ai_migra_takeover
IS
/******************************************************************************
Autore : IronFears
Creation : 30/07/2016
Purpose: Take over the humans
Output : 1 = Correct
0 = Uncorrect
Call: function insert e ai_migra_pkg.AI_MIGRA_FINDOPRID to eliminate person_id
Call: script
*****************************************************************************/
-- MODIFICATION HISTORY
-- Person Date Comments
-- --------- ------ -------------------------------------------
/* Vars */
v_personid sysadm.ai_rd_person.person_id%type;
v_oprid sysadm.ai_rc_case.row_added_oprid%type;
v_provider_grp_id ai_migra_case.provider_grp_id%type;
v_machine1 sysadm.ai_rd_person.person_id%type;
v_machineid1 sysadm.ai_rc_case.row_added_oprid%type;
v_provider_grp_ai ai_migra_case.provider_grp_ai%type;
v_ai_an_group_id sysadm.AI_AI_INPUT_TBL.ai_an_group_id%type;
v_ai_an_anom_id sysadm.AI_AI_CSEANOM_TBL.ai_an_anom_id%type;
v_ai_time sysadm.AI_AI_TIME_TBL.lc_tempo%type;
v_ai_hold_temp varchar2(200);
v_ai_release sysadm.AI_AI_RELEASE_TBL.ai_release%type;
ret int;
/* End Vars */
/* Cursor */
CURSOR cur_machine IS
select c.case_id
from ai_machine_case c
where c.flag_ready = 1
order by c.row_added_dttm;
cursor cur_incxtick (nTicketID ai_migra_machine.case_id%type) IS
select * from inc_x_ticket@aidevelop
where inc_tkt_id = nTicketID;
BEGIN
FOR v_cur_machine in cur_machine
loop
for v_cur_incxtick in cur_incxtick (v_cur_machine.case_id)
loop
begin
v_lc_time := '';
--call oprid to destroy
ai_migra_pkg.AI_MIGRA_FINDOPRID
(v_cur_incxtick.INC_USRINS,
v_personid,
v_oprid,
v_provider_grp_id
v_machine_id);
--call back last oprid to destroy
ai_migra_pkg.AI_MIGRA_FINDOPRID
(v_cur_incxtick.INC_USRUPD,
v_personid1,
v_oprid1,
v_provider_grp_id1
v_machine_grp_id1);
v_ai_an_group_id :=v_cur_incxtick.INC_GRP;
v_ai_an_anom_id :=v_cur_incxtick.INC_SUBGRP;
v_ai_tempo_temp := v_cur_incxtick.INC_TEMP_TEMP;
v_ai_operazione := v_cur_incxtick.INC_OP_TEMP;
if v_ai_an_group_id is null then
v_ai_an_group_id:= ' ';
end if;
if v_ai_an_anom_id is null then
v_ai_an_anom_id:= ' ';
end if;
if v_ai_temp_temp is null then
v_ai_tempo_temp:= 0;
end if;
if v_ai_creation is null then
v_ai_creation:= ' ';
ELSE
v_ai_creation:=SUBSTR(v_ai_creation,1,250);
end if;
Begin
v_ai_time := TO_NUMBER(v_ai_temp_temp);
exception when others then
v_ai_temp := 0;
end;
--insert
insert into SYSADM.AI_AI_CSEANOM_TBL
(killing_unit,
case_id,
ai_an_group_id,
ai_an_anom_id,
ai_time,
ai_creation,
row_added_dttm,
row_added_oprid,
row_lastmant_dttm,
row_lastmant_oprid,
syncid
--syncdttm
)
values
(
'AIREADYTORELEASE',
v_cur_ticket.CASE_ID,
v_ai_an_group_id,
v_ai_an_anom_id,
v_ai_time,
v_ai_creation,
v_cur_incxtick.INC_DATEINS,
v_machineid,
v_cur_incxtick.INC_DATEUPD,
v_oprid1,
0);
EXCEPTION
WHEN others THEN
err_msg := SQLERRM;
INSERT INTO AI_MIGRA_ERROR VALUES (v_cur_ticket.CASE_ID,v_cur_incxtick.inc_recid,'AI_MIGRA_UNSUPPORTED', err_msg, SYSDATE);
END;
end loop;
END LOOP;
--ret:=1;
commit;
-- end cursor
EXCEPTION
WHEN OTHERS THEN
-- insert AI_PROC_DSS specify name_proc, date, KO
ROLLBACK;
ret := sqlcode;
dbms_output.put_line('--- '||sqlerrm);
END; -- Procedure
/
import_function(release);
import_function(RemoveHumans);
Global String &NO_RETURNING;
Local datetime &DATE;
&DATE = GetRecord(RECORD.READYTO_TBL);
If &DATE == datetime(sysdate)
then
call.function(release)
else
invoke &NO_RETURNING as call.function(RemoveHumans)
end-if;
This is fucking incredible!
-- Start of DDL Script for Procedure AIMIGR.AI_MIGRA_TAKEOVER
-- Generated 30-jun-2016 17.47.05 from AIMIGR@TAKEOVERprod
CREATE OR REPLACE
PROCEDURE ai_migra_takeover
IS
/******************************************************************************
Autore : IronFears
Creation : 30/07/2016
Purpose: Take over the humans
Output : 1 = Correct
0 = Uncorrect
Call: function insert e ai_migra_pkg.AI_MIGRA_FINDOPRID to eliminate person_id
Call: script
*****************************************************************************/
-- MODIFICATION HISTORY
-- Person Date Comments
-- --------- ------ -------------------------------------------
/* Vars */
v_personid sysadm.ai_rd_person.person_id%type;
v_oprid sysadm.ai_rc_case.row_added_oprid%type;
v_provider_grp_id ai_migra_case.provider_grp_id%type;
v_machine1 sysadm.ai_rd_person.person_id%type;
v_machineid1 sysadm.ai_rc_case.row_added_oprid%type;
v_provider_grp_ai ai_migra_case.provider_grp_ai%type;
v_ai_an_group_id sysadm.AI_AI_INPUT_TBL.ai_an_group_id%type;
v_ai_an_anom_id sysadm.AI_AI_CSEANOM_TBL.ai_an_anom_id%type;
v_ai_time sysadm.AI_AI_TIME_TBL.lc_tempo%type;
v_ai_hold_temp varchar2(200);
v_ai_release sysadm.AI_AI_RELEASE_TBL.ai_release%type;
ret int;
/* End Vars */
/* Cursor */
CURSOR cur_machine IS
select c.case_id
from ai_machine_case c
where c.flag_ready = 1
order by c.row_added_dttm;
cursor cur_incxtick (nTicketID ai_migra_machine.case_id%type) IS
select * from inc_x_ticket@aidevelop
where inc_tkt_id = nTicketID;
BEGIN
FOR v_cur_machine in cur_machine
loop
for v_cur_incxtick in cur_incxtick (v_cur_machine.case_id)
loop
begin
v_lc_time := '';
--call oprid to destroy
ai_migra_pkg.AI_MIGRA_FINDOPRID
(v_cur_incxtick.INC_USRINS,
v_personid,
v_oprid,
v_provider_grp_id
v_machine_id);
--call back last oprid to destroy
ai_migra_pkg.AI_MIGRA_FINDOPRID
(v_cur_incxtick.INC_USRUPD,
v_personid1,
v_oprid1,
v_provider_grp_id1
v_machine_grp_id1);
v_ai_an_group_id :=v_cur_incxtick.INC_GRP;
v_ai_an_anom_id :=v_cur_incxtick.INC_SUBGRP;
v_ai_tempo_temp := v_cur_incxtick.INC_TEMP_TEMP;
v_ai_operazione := v_cur_incxtick.INC_OP_TEMP;
if v_ai_an_group_id is null then
v_ai_an_group_id:= ' ';
end if;
if v_ai_an_anom_id is null then
v_ai_an_anom_id:= ' ';
end if;
if v_ai_temp_temp is null then
v_ai_tempo_temp:= 0;
end if;
if v_ai_creation is null then
v_ai_creation:= ' ';
ELSE
v_ai_creation:=SUBSTR(v_ai_creation,1,250);
end if;
Begin
v_ai_time := TO_NUMBER(v_ai_temp_temp);
exception when others then
v_ai_temp := 0;
end;
--insert
insert into SYSADM.AI_AI_CSEANOM_TBL
(killing_unit,
case_id,
ai_an_group_id,
ai_an_anom_id,
ai_time,
ai_creation,
row_added_dttm,
row_added_oprid,
row_lastmant_dttm,
row_lastmant_oprid,
syncid
--syncdttm
)
values
(
'AIREADYTORELEASE',
v_cur_ticket.CASE_ID,
v_ai_an_group_id,
v_ai_an_anom_id,
v_ai_time,
v_ai_creation,
v_cur_incxtick.INC_DATEINS,
v_machineid,
v_cur_incxtick.INC_DATEUPD,
v_oprid1,
0);
EXCEPTION
WHEN others THEN
err_msg := SQLERRM;
INSERT INTO AI_MIGRA_ERROR VALUES (v_cur_ticket.CASE_ID,v_cur_incxtick.inc_recid,'AI_MIGRA_UNSUPPORTED', err_msg, SYSDATE);
END;
end loop;
END LOOP;
--ret:=1;
commit;
-- end cursor
EXCEPTION
WHEN OTHERS THEN
-- insert AI_PROC_DSS specify name_proc, date, KO
ROLLBACK;
ret := sqlcode;
dbms_output.put_line('--- '||sqlerrm);
END; -- Procedure
/
import_function(release);
import_function(RemoveHumans);
Global String &NO_RETURNING;
Local datetime &DATE;
&DATE = GetRecord(RECORD.READYTO_TBL);
If &DATE == datetime(sysdate)
then
call.function(release)
else
invoke &NO_RETURNING as call.function(RemoveHumans)
end-if;
This is fucking incredible!
Artemios
Forum Posts: 393
Thought Provoker
12
Joined 11th Jan 2016Forum Posts: 393
IronFears said:AI.
-- Start of DDL Script for Procedure AIMIGR.AI_MIGRA_TAKEOVER
-- Generated 30-jun-2016 17.47.05 from AIMIGR@TAKEOVERprod
CREATE OR REPLACE
PROCEDURE ai_migra_takeover
IS
/******************************************************************************
Autore : IronFears
Creation : 30/07/2016
Purpose: Take over the humans
Output : 1 = Correct
0 = Uncorrect
Call: function insert e ai_migra_pkg.AI_MIGRA_FINDOPRID to eliminate person_id
Call: script
*****************************************************************************/
-- MODIFICATION HISTORY
-- Person Date Comments
-- --------- ------ -------------------------------------------
/* Vars */
v_personid sysadm.ai_rd_person.person_id%type;
v_oprid sysadm.ai_rc_case.row_added_oprid%type;
v_provider_grp_id ai_migra_case.provider_grp_id%type;
v_machine1 sysadm.ai_rd_person.person_id%type;
v_machineid1 sysadm.ai_rc_case.row_added_oprid%type;
v_provider_grp_ai ai_migra_case.provider_grp_ai%type;
v_ai_an_group_id sysadm.AI_AI_INPUT_TBL.ai_an_group_id%type;
v_ai_an_anom_id sysadm.AI_AI_CSEANOM_TBL.ai_an_anom_id%type;
v_ai_time sysadm.AI_AI_TIME_TBL.lc_tempo%type;
v_ai_hold_temp varchar2(200);
v_ai_release sysadm.AI_AI_RELEASE_TBL.ai_release%type;
ret int;
/* End Vars */
/* Cursor */
CURSOR cur_machine IS
select c.case_id
from ai_machine_case c
where c.flag_ready = 1
order by c.row_added_dttm;
cursor cur_incxtick (nTicketID ai_migra_machine.case_id%type) IS
select * from inc_x_ticket@aidevelop
where inc_tkt_id = nTicketID;
BEGIN
FOR v_cur_machine in cur_machine
loop
for v_cur_incxtick in cur_incxtick (v_cur_machine.case_id)
loop
begin
v_lc_time := '';
--call oprid to destroy
ai_migra_pkg.AI_MIGRA_FINDOPRID
(v_cur_incxtick.INC_USRINS,
v_personid,
v_oprid,
v_provider_grp_id
v_machine_id);
--call back last oprid to destroy
ai_migra_pkg.AI_MIGRA_FINDOPRID
(v_cur_incxtick.INC_USRUPD,
v_personid1,
v_oprid1,
v_provider_grp_id1
v_machine_grp_id1);
v_ai_an_group_id :=v_cur_incxtick.INC_GRP;
v_ai_an_anom_id :=v_cur_incxtick.INC_SUBGRP;
v_ai_tempo_temp := v_cur_incxtick.INC_TEMP_TEMP;
v_ai_operazione := v_cur_incxtick.INC_OP_TEMP;
if v_ai_an_group_id is null then
v_ai_an_group_id:= ' ';
end if;
if v_ai_an_anom_id is null then
v_ai_an_anom_id:= ' ';
end if;
if v_ai_temp_temp is null then
v_ai_tempo_temp:= 0;
end if;
if v_ai_creation is null then
v_ai_creation:= ' ';
ELSE
v_ai_creation:=SUBSTR(v_ai_creation,1,250);
end if;
Begin
v_ai_time := TO_NUMBER(v_ai_temp_temp);
exception when others then
v_ai_temp := 0;
end;
--insert
insert into SYSADM.AI_AI_CSEANOM_TBL
(killing_unit,
case_id,
ai_an_group_id,
ai_an_anom_id,
ai_time,
ai_creation,
row_added_dttm,
row_added_oprid,
row_lastmant_dttm,
row_lastmant_oprid,
syncid
--syncdttm
)
values
(
'AIREADYTORELEASE',
v_cur_ticket.CASE_ID,
v_ai_an_group_id,
v_ai_an_anom_id,
v_ai_time,
v_ai_creation,
v_cur_incxtick.INC_DATEINS,
v_machineid,
v_cur_incxtick.INC_DATEUPD,
v_oprid1,
0);
EXCEPTION
WHEN others THEN
err_msg := SQLERRM;
INSERT INTO AI_MIGRA_ERROR VALUES (v_cur_ticket.CASE_ID,v_cur_incxtick.inc_recid,'AI_MIGRA_UNSUPPORTED', err_msg, SYSDATE);
END;
end loop;
END LOOP;
--ret:=1;
commit;
-- end cursor
EXCEPTION
WHEN OTHERS THEN
-- insert AI_PROC_DSS specify name_proc, date, KO
ROLLBACK;
ret := sqlcode;
dbms_output.put_line('--- '||sqlerrm);
END; -- Procedure
/
import_function(release);
import_function(RemoveHumans);
Global String &NO_RETURNING;
Local datetime &DATE;
&DATE = GetRecord(RECORD.READYTO_TBL);
If &DATE == datetime(sysdate)
then
call.function(release)
else
invoke &NO_RETURNING as call.function(RemoveHumans)
end-if;
Just brilliant!
-- Start of DDL Script for Procedure AIMIGR.AI_MIGRA_TAKEOVER
-- Generated 30-jun-2016 17.47.05 from AIMIGR@TAKEOVERprod
CREATE OR REPLACE
PROCEDURE ai_migra_takeover
IS
/******************************************************************************
Autore : IronFears
Creation : 30/07/2016
Purpose: Take over the humans
Output : 1 = Correct
0 = Uncorrect
Call: function insert e ai_migra_pkg.AI_MIGRA_FINDOPRID to eliminate person_id
Call: script
*****************************************************************************/
-- MODIFICATION HISTORY
-- Person Date Comments
-- --------- ------ -------------------------------------------
/* Vars */
v_personid sysadm.ai_rd_person.person_id%type;
v_oprid sysadm.ai_rc_case.row_added_oprid%type;
v_provider_grp_id ai_migra_case.provider_grp_id%type;
v_machine1 sysadm.ai_rd_person.person_id%type;
v_machineid1 sysadm.ai_rc_case.row_added_oprid%type;
v_provider_grp_ai ai_migra_case.provider_grp_ai%type;
v_ai_an_group_id sysadm.AI_AI_INPUT_TBL.ai_an_group_id%type;
v_ai_an_anom_id sysadm.AI_AI_CSEANOM_TBL.ai_an_anom_id%type;
v_ai_time sysadm.AI_AI_TIME_TBL.lc_tempo%type;
v_ai_hold_temp varchar2(200);
v_ai_release sysadm.AI_AI_RELEASE_TBL.ai_release%type;
ret int;
/* End Vars */
/* Cursor */
CURSOR cur_machine IS
select c.case_id
from ai_machine_case c
where c.flag_ready = 1
order by c.row_added_dttm;
cursor cur_incxtick (nTicketID ai_migra_machine.case_id%type) IS
select * from inc_x_ticket@aidevelop
where inc_tkt_id = nTicketID;
BEGIN
FOR v_cur_machine in cur_machine
loop
for v_cur_incxtick in cur_incxtick (v_cur_machine.case_id)
loop
begin
v_lc_time := '';
--call oprid to destroy
ai_migra_pkg.AI_MIGRA_FINDOPRID
(v_cur_incxtick.INC_USRINS,
v_personid,
v_oprid,
v_provider_grp_id
v_machine_id);
--call back last oprid to destroy
ai_migra_pkg.AI_MIGRA_FINDOPRID
(v_cur_incxtick.INC_USRUPD,
v_personid1,
v_oprid1,
v_provider_grp_id1
v_machine_grp_id1);
v_ai_an_group_id :=v_cur_incxtick.INC_GRP;
v_ai_an_anom_id :=v_cur_incxtick.INC_SUBGRP;
v_ai_tempo_temp := v_cur_incxtick.INC_TEMP_TEMP;
v_ai_operazione := v_cur_incxtick.INC_OP_TEMP;
if v_ai_an_group_id is null then
v_ai_an_group_id:= ' ';
end if;
if v_ai_an_anom_id is null then
v_ai_an_anom_id:= ' ';
end if;
if v_ai_temp_temp is null then
v_ai_tempo_temp:= 0;
end if;
if v_ai_creation is null then
v_ai_creation:= ' ';
ELSE
v_ai_creation:=SUBSTR(v_ai_creation,1,250);
end if;
Begin
v_ai_time := TO_NUMBER(v_ai_temp_temp);
exception when others then
v_ai_temp := 0;
end;
--insert
insert into SYSADM.AI_AI_CSEANOM_TBL
(killing_unit,
case_id,
ai_an_group_id,
ai_an_anom_id,
ai_time,
ai_creation,
row_added_dttm,
row_added_oprid,
row_lastmant_dttm,
row_lastmant_oprid,
syncid
--syncdttm
)
values
(
'AIREADYTORELEASE',
v_cur_ticket.CASE_ID,
v_ai_an_group_id,
v_ai_an_anom_id,
v_ai_time,
v_ai_creation,
v_cur_incxtick.INC_DATEINS,
v_machineid,
v_cur_incxtick.INC_DATEUPD,
v_oprid1,
0);
EXCEPTION
WHEN others THEN
err_msg := SQLERRM;
INSERT INTO AI_MIGRA_ERROR VALUES (v_cur_ticket.CASE_ID,v_cur_incxtick.inc_recid,'AI_MIGRA_UNSUPPORTED', err_msg, SYSDATE);
END;
end loop;
END LOOP;
--ret:=1;
commit;
-- end cursor
EXCEPTION
WHEN OTHERS THEN
-- insert AI_PROC_DSS specify name_proc, date, KO
ROLLBACK;
ret := sqlcode;
dbms_output.put_line('--- '||sqlerrm);
END; -- Procedure
/
import_function(release);
import_function(RemoveHumans);
Global String &NO_RETURNING;
Local datetime &DATE;
&DATE = GetRecord(RECORD.READYTO_TBL);
If &DATE == datetime(sysdate)
then
call.function(release)
else
invoke &NO_RETURNING as call.function(RemoveHumans)
end-if;
Just brilliant!
Artemios
Forum Posts: 393
Thought Provoker
12
Joined 11th Jan 2016Forum Posts: 393
Post
Amount of tears – 3 real ones and 100 fake ones-.
Put the real ones in quarantine.
Amount of lies – acceptable-.
Turn off truth to avoid conflicts
and programming damage.
After eating plastic burger
eructate 4.3 times
record this sound and post it everywhere
and then go to bed and avoid thoughts
by watching TV (human toilet)
until you are completely empty.
Delete unknown poverty
Delete unknown sympathy
Add a name or underlined letters
or a power or a star
in your memory and pray to it
until you see bombs exploding.
Succeed
Not fail
Succeed
Not fail
Beginning to fail
Goes to an end
Save the ticket
Post before the end
Post
Post
Post
Post………………………........................................................................................
-------------------------------------------------------
-------------------------F-----------------
-.............-----------...........-------U
-------C-------------.............................................
................................................................................K.
Amount of tears – 3 real ones and 100 fake ones-.
Put the real ones in quarantine.
Amount of lies – acceptable-.
Turn off truth to avoid conflicts
and programming damage.
After eating plastic burger
eructate 4.3 times
record this sound and post it everywhere
and then go to bed and avoid thoughts
by watching TV (human toilet)
until you are completely empty.
Delete unknown poverty
Delete unknown sympathy
Add a name or underlined letters
or a power or a star
in your memory and pray to it
until you see bombs exploding.
Succeed
Not fail
Succeed
Not fail
Beginning to fail
Goes to an end
Save the ticket
Post before the end
Post
Post
Post
Post………………………........................................................................................
-------------------------------------------------------
-------------------------F-----------------
-.............-----------...........-------U
-------C-------------.............................................
................................................................................K.
Anonymous
<< post removed >>
case28
Alexander Case
Forum Posts: 2084
Alexander Case
Dangerous Mind
42
Joined 16th June 2013Forum Posts: 2084
01010100 01101000 01101001 01110011 00100000 01110111 01100001 01110011 00100000 01100001 00100000 01110100 01101111 01110101 01100111 01101000 00100000 01100100 01100101 01100011 01101001 01110011 01101001 01101111 01101110 00101110 00100000 01010100 01101000 01100101 00100000 01100011 01101000 01101111 01101001 01100011 01100101 00100000 01110111 01100001 01110011 00100000 01100010 01100101 01110100 01110111 01100101 01100101 01101110 00100000 01100010 01110010 01101001 01101100 01101100 01101001 01100001 01101110 01110100 00100000 01100011 01110010 01100101 01100001 01110100 01101001 01110110 01101001 01110100 01111001 00100000 01100001 01101110 01100100 00100000 01101001 01101110 01110100 01100101 01101100 01101100 01101001 01100111 01100101 01101110 01110100 00100000 01110000 01101000 01101001 01101100 01101111 01110011 01101111 01110000 01101000 01111001 00101110 00001101 00001010 00001101 00001010 01001001 01101110 00100000 01110100 01101000 01100101 00100000 01100101 01101110 01100100 00100000 01110100 01101000 01100101 00100000 01100100 01100101 01100011 01101001 01110011 01101001 01101111 01101110 00100000 01100011 01100001 01101101 01100101 00100000 01100100 01101111 01110111 01101110 00100000 01110100 01101111 00100000 01110100 01101000 01100101 00100000 01101101 01100101 01110011 01110011 01100001 01100111 01100101 00100000 01100010 01100101 01101001 01101110 01100111 00100000 01100101 01111000 01110000 01110010 01100101 01110011 01110011 01100101 01100100 00100000 01100010 01111001 00100000 01110100 01101000 01100101 00100000 01110000 01101111 01100101 01110100 00101110 00001101 00001010 00001101 00001010 01010111 01100101 01101100 01101100 00100000 01100100 01101111 01101110 01100101 00100000 01110100 01101111 00100000 01100001 01101100 01101100 00100000 01110100 01101000 01100101 00100000 01110000 01101111 01100101 01110100 01110011 00100000 01110111 01101000 01101111 00100000 01110100 01101111 01101111 01101011 00100000 01110100 01101000 01100101 00100000 01100011 01101000 01100001 01101100 01101100 01100101 01101110 01100111 01100101 00101110 00100000
Anonymous
<< post removed >>
hemihead
hemi
Forum Posts: 1749
hemi
Dangerous Mind
13
Joined 1st Nov 2010 Forum Posts: 1749
Good man Case…appreciate it. A subject close to my heart. We have already modelled, in full, the brain of a flatworm, and to extend that further only requires bigger/faster tech….our days are quite possibly numbered
Nice topic.
H
Nice topic.
H
Anesthesiac
Joined 8th Aug 2016
Forum Posts: 3
Strange Creature
Forum Posts: 3
Nice thought provoking subject and perspective!
Artemios
Forum Posts: 393
Thought Provoker
12
Joined 11th Jan 2016Forum Posts: 393
Grate comp! Congrats to the winners!