Oracle function or procedure

From: svein <sveinf_at_petrodata.no>
Date: Fri, 14 May 1999 08:55:46 +0200
Message-ID: <373BC8F2.1BA8407B@petrodata.no>

Hello!

I tried to make a function insert a new record in one of my tables and return the NEXTVAL value of the sequence on the index of the table.
The server responded "Function does not guarantee not to update the database".
Does this mean I have to use a procedure to insert new records? I tried with a procedure:

CREATE OR REPLACE PROCEDURE ADD_JOB(

 TYPE IN VARCHAR2,
 DISK IN VARCHAR2,
 NAME IN VARCHAR2,
 DATE IN VARCHAR2,

 CLIENT IN VARCHAR2,
 TEST IN VARCHAR2,
 TEST_S IN VARCHAR2,
 STATE IN VARCHAR2,
 CREATOR IN VARCHAR2)
as
BEGIN
select SEQ.NEXTVAL into JOB_ID from dual; insert into JOB values
(JOB_ID, TYPE, DISK, NAME, DATE, CLIENT, TEST, TEST_S, STATE, CREATOR); END;
/

But the server responds
"Procedure created with compilation errors", and I can't see where I do my mistakes... How can I return the true NEXTVAL value if I must use a procedure to insert records? Returning CURRVAL is not enough...

I'd be greatful if someone could help me

Regards,
Svein Received on Fri May 14 1999 - 01:55:46 CDT