Skip to Main Content

Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

how to read an ARPA file in java

839722Feb 14 2011 — edited Feb 15 2011
Hi
Im new in java and dont know many thing about it, I want to know how can read an ARPA file in java.
pleas describ it step bye step and esy to understand.

Edited by: 836719 on Feb 14, 2011 8:15 PM

Comments

Hoek
Does :NEW.UUID have any value?
Usually these columns are populated through calls to some SEQUENCE.NEXTVAL value.
How are you populating the column?
Solomon Yakobson
Are you creating trigger using OEM and target database 9i? If so, there is a bug. Use other tool, e.g. SQL*Plus.

SY.
752032
In this case the UUID column is a nvarchar2(100) and is provided in the insert action....

Thanx for your response.
752032
No, I'm using OEM from client 10g and oracle database 10g

Thanx for your response...
Syed Ullah
Try putting a DBMS_OUTPUT.PUT_LINE() in your trigger to print the value of :NEW.UUID
and then do an insert in SQLPLUS to see what value gets printed for :NEW.UUID.
752032
The problem is: I can't save the trigger, it shows me the error message: "Missing IN or OUT parameter at index:: 1" and fails...
I'm working over the OEM
Syed Ullah
Try saving it using SQLPLUS and if that works that may indicate some bug on the OEM side.
752032
When I execute the script:

CREATE OR REPLACE TRIGGER "KIKO"."TR_INSERT_PERSON" AFTER
INSERT ON "KIKO"."PERSON" FOR EACH ROW BEGIN
INSERT INTO CHANGETABLE (ROWGUID, OPERATION, DATEOPERATION, TABLEID) VALUES (:NEW.UUID, 2, (SELECT SYSDATE FROM DUAL), 'PERSON');
END;Connect sys/****@orcl AS SYSDBA

It shows me the warning: "Trigger created with compilation errors."
It seems like a syntax or semantic error
Syed Ullah
Type 'show error' to see the errors.
Solomon Yakobson
Answer
Try the following in SQL*Plus:
CREATE OR REPLACE
  TRIGGER KIKO.TR_INSERT_PERSON
    AFTER INSERT
    ON KIKO.PERSON
    FOR EACH ROW
    BEGIN 
        INSERT
          INTO CHANGETABLE(
                           ROWGUID,
                           OPERATION,
                           DATEOPERATION,
                           TABLEID
                          )
          VALUES (
                  :NEW.UUID,
                  2,
                  SYSDATE,
                  'PERSON'
                 );
END;
/
SHOW ERRORS TRIGGER KIKO.TR_INSERT_PERSON
SY.
Marked as Answer by 752032 · Sep 27 2020
752032
The error message is: "Missing IN or OUT parameter at index:: 1"
752032
Seems like it works!!! Could you explain me what happened???
Solomon Yakobson
user12572223 wrote:
Seems like it works!!! Could you explain me what happened???
Could you provide create table statements for tables PERSON and CHANGETABLE.

SY.
1 - 13
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 15 2011
Added on Feb 14 2011
6 comments
432 views