On Aug 5, 3:07 pm, Aya the Vampire Slayer
<ry... (AT) gatech (DOT) rmv.this.part.edu> wrote:

Ok, Well, maybe I'm a dingbat here, but help me out:

I create a view: CREATE VIEW V1 as SELECT TABLE1.*, NULL SOURCE FROM
TABLE1;

That creates a view identical to TABLE1 with an extra column named
SOURCE.

Now, in my INSTEAD OF trigger I can insert into any table I code for,
right? So, within the body of the trigger I can say: INSERT INTO
TABLEB VALUES (.........).

That should work, right? I'm just confused on where the originating
DML operation goes. Is the purpose of the trigger to not insert into
the base tables, but just execute the code?

artmerar (AT) yahoo (DOT) com wa:
For an INSTEAD OF trigger, you will have to write both the "INSERT INTO
TABLE1 [...]" and "INSERT INTO TABLE2 [...]" DML statements into the
body of the trigger.

"INSTEAD OF", as the name implies, does whatever is in the body of the
trigger instead of doing the actual DML action that triggered it. So,
for an INSTEAD OF INSERT trigger, if you want it to actually do the
INSERT that triggered it in the first place, you will have to write it
into the body of the trigger explicitly. (for the record, INSTEAD OF
triggers can only be used with views)


--
"Care must be exorcised when handring Opiticar System as it is apts to
be sticked by dusts and hand-fat." --Japanese Translators

"Keep your fingers off the lens." --Elton Byington, English Translator

artmerar (AT) yahoo (DOT) com wa:
For an INSTEAD OF trigger, you will have to write both the "INSERT INTO
TABLE1 [...]" and "INSERT INTO TABLE2 [...]" DML statements into the
body of the trigger.

"INSTEAD OF", as the name implies, does whatever is in the body of the
trigger instead of doing the actual DML action that triggered it. So,
for an INSTEAD OF INSERT trigger, if you want it to actually do the
INSERT that triggered it in the first place, you will have to write it
into the body of the trigger explicitly. (for the record, INSTEAD OF
triggers can only be used with views)


--
"Care must be exorcised when handring Opiticar System as it is apts to
be sticked by dusts and hand-fat." --Japanese Translators

"Keep your fingers off the lens." --Elton Byington, English Translator

artmerar (AT) yahoo (DOT) com wa:
For an INSTEAD OF trigger, you will have to write both the "INSERT INTO
TABLE1 [...]" and "INSERT INTO TABLE2 [...]" DML statements into the
body of the trigger.

"INSTEAD OF", as the name implies, does whatever is in the body of the
trigger instead of doing the actual DML action that triggered it. So,
for an INSTEAD OF INSERT trigger, if you want it to actually do the
INSERT that triggered it in the first place, you will have to write it
into the body of the trigger explicitly. (for the record, INSTEAD OF
triggers can only be used with views)


--
"Care must be exorcised when handring Opiticar System as it is apts to
be sticked by dusts and hand-fat." --Japanese Translators

"Keep your fingers off the lens." --Elton Byington, English Translator

artmerar (AT) yahoo (DOT) com wa:
For an INSTEAD OF trigger, you will have to write both the "INSERT INTO
TABLE1 [...]" and "INSERT INTO TABLE2 [...]" DML statements into the
body of the trigger.

"INSTEAD OF", as the name implies, does whatever is in the body of the
trigger instead of doing the actual DML action that triggered it. So,
for an INSTEAD OF INSERT trigger, if you want it to actually do the
INSERT that triggered it in the first place, you will have to write it
into the body of the trigger explicitly. (for the record, INSTEAD OF
triggers can only be used with views)


--
"Care must be exorcised when handring Opiticar System as it is apts to
be sticked by dusts and hand-fat." --Japanese Translators

"Keep your fingers off the lens." --Elton Byington, English Translator

On Aug 5, 3:26 pm, Aya the Vampire Slayer
<ry... (AT) gatech (DOT) rmv.this.part.edu> wrote:

Thanks, but I still need to resolve the ORA-07445 that I am
receiving. If you do not mind, I can post some of my code. Maybe I
did something wrong??

Here is the view:

CREATE OR REPLACE VIEW CUSTOMER_CONFIG_VW
(CUSTOMER_ID, PRODUCT_ID, FORMAT, STATUS, DATE_ADDED, DATE_MODIFIED,
SOURCE) AS
SELECT CUSTOMER_ID, PRODUCT_ID, FORMAT, STATUS, DATE_ADDED,
DATE_MODIFIED", NULL source
FROM customer_config;

Here is part of, not the entire, trigger:

CREATE OR REPLACE TRIGGER customer_config_trg
INSTEAD OF UPDATE OR INSERT ON customer_config_vw
FOR EACH ROW

INSERT INTO customer_config_hist
VALUES
(:NEW.customer_id, :NEW.product_id, :NEW.format, :NEW.status, :NEW.source,
SYSDATE);

When I do the insert into the view I get:

ORA-07445: exception encountered: core dump [_intel_fast_memcpy.J()
+30] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []

Any thoughts?

On Aug 5, 3:26 pm, Aya the Vampire Slayer
<ry... (AT) gatech (DOT) rmv.this.part.edu> wrote:

Thanks, but I still need to resolve the ORA-07445 that I am
receiving. If you do not mind, I can post some of my code. Maybe I
did something wrong??

Here is the view:

CREATE OR REPLACE VIEW CUSTOMER_CONFIG_VW
(CUSTOMER_ID, PRODUCT_ID, FORMAT, STATUS, DATE_ADDED, DATE_MODIFIED,
SOURCE) AS
SELECT CUSTOMER_ID, PRODUCT_ID, FORMAT, STATUS, DATE_ADDED,
DATE_MODIFIED", NULL source
FROM customer_config;

Here is part of, not the entire, trigger:

CREATE OR REPLACE TRIGGER customer_config_trg
INSTEAD OF UPDATE OR INSERT ON customer_config_vw
FOR EACH ROW

INSERT INTO customer_config_hist
VALUES
(:NEW.customer_id, :NEW.product_id, :NEW.format, :NEW.status, :NEW.source,
SYSDATE);

When I do the insert into the view I get:

ORA-07445: exception encountered: core dump [_intel_fast_memcpy.J()
+30] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []

Any thoughts?

On Aug 5, 3:26 pm, Aya the Vampire Slayer
<ry... (AT) gatech (DOT) rmv.this.part.edu> wrote:

Thanks, but I still need to resolve the ORA-07445 that I am
receiving. If you do not mind, I can post some of my code. Maybe I
did something wrong??

Here is the view:

CREATE OR REPLACE VIEW CUSTOMER_CONFIG_VW
(CUSTOMER_ID, PRODUCT_ID, FORMAT, STATUS, DATE_ADDED, DATE_MODIFIED,
SOURCE) AS
SELECT CUSTOMER_ID, PRODUCT_ID, FORMAT, STATUS, DATE_ADDED,
DATE_MODIFIED", NULL source
FROM customer_config;

Here is part of, not the entire, trigger:

CREATE OR REPLACE TRIGGER customer_config_trg
INSTEAD OF UPDATE OR INSERT ON customer_config_vw
FOR EACH ROW

INSERT INTO customer_config_hist
VALUES
(:NEW.customer_id, :NEW.product_id, :NEW.format, :NEW.status, :NEW.source,
SYSDATE);

When I do the insert into the view I get:

ORA-07445: exception encountered: core dump [_intel_fast_memcpy.J()
+30] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []

Any thoughts?

On Aug 5, 3:26 pm, Aya the Vampire Slayer
<ry... (AT) gatech (DOT) rmv.this.part.edu> wrote:

Thanks, but I still need to resolve the ORA-07445 that I am
receiving. If you do not mind, I can post some of my code. Maybe I
did something wrong??

Here is the view:

CREATE OR REPLACE VIEW CUSTOMER_CONFIG_VW
(CUSTOMER_ID, PRODUCT_ID, FORMAT, STATUS, DATE_ADDED, DATE_MODIFIED,
SOURCE) AS
SELECT CUSTOMER_ID, PRODUCT_ID, FORMAT, STATUS, DATE_ADDED,
DATE_MODIFIED", NULL source
FROM customer_config;

Here is part of, not the entire, trigger:

CREATE OR REPLACE TRIGGER customer_config_trg
INSTEAD OF UPDATE OR INSERT ON customer_config_vw
FOR EACH ROW

INSERT INTO customer_config_hist
VALUES
(:NEW.customer_id, :NEW.product_id, :NEW.format, :NEW.status, :NEW.source,
SYSDATE);

When I do the insert into the view I get:

ORA-07445: exception encountered: core dump [_intel_fast_memcpy.J()
+30] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []

Any thoughts?

artmerar (AT) yahoo (DOT) com wa:
I'm going to assume from here on out that Table1 is "CUSTOMER_CONFIG"
and Table2 is "CUSTOMER_CONFIG_HIST". Replace with actual tablenames as
needed.

I am not familiar with this syntax, so I can't say if it's correct or
not. But here's how I would write it:

create or replace view customer_config_vw as
select CUSTOMER_ID,
PRODUCT_ID,
FORMAT,
STATUS,
DATE_ADDED,
DATE_MODIFIED,
null SOURCE
from CUSTOMER_CONFIG
;


Ah, an UPDATE OR INSERT one. I can't check for syntax on this one since
I'm at home, but here:


create or replace trigger customer_config_trg
INSTEAD OF UPDATE OR INSERT
ON customer_config_vw
FOR EACH ROW
<var declarations if needed>
BEGIN
if INSERTING then
-- insert into the main table
INSERT INTO CUSTOMER_CONFIG
(CUSTOMER_ID, PRODUCT_ID, FORMAT, STATUS, DATE_ADDED, DATE_MODIFIED)
VALUES (:new.CUSTOMER_ID, :new.PRODUCT_ID, :new.FORMAT, :new.STATUS,
:new.DATE_ADDED, :new.DATE_MODIFIED);

-- insert into the history table
INSERT INTO CUSTOMER_CONFIG_HIST
(CUSTOMER_ID, PRODUCT_ID, FORMAT, STATUS, DATE_ADDED,
DATE_MODIFIED, SOURCE)
VALUES (:new.CUSTOMER_ID, :new.PRODUCT_ID, :new.FORMAT, :new.STATUS,
:new.DATE_ADDED, :new.DATE_MODIFIED, :new.SOURCE);

else
-- update the main table
UPDATE CUSTOMER_CONFIG
[... fields ...]
where [...];

-- update the history table
UPDATE CUSTOMER_CONFIG_HIST
[...]
where [... fields ...];
end if;
END;
/


That seems like a pretty generic error. I'm not sure I can help you much
more beyond this, you'll probably just have to play around with the
syntax. I have gotten this approach to work many many times in the past,
though, so you should eventually be able to get it to work.


--
"Care must be exorcised when handring Opiticar System as it is apts to
be sticked by dusts and hand-fat." --Japanese Translators

"Keep your fingers off the lens." --Elton Byington, English Translator