- Joined
- Oct 28, 2006
- Messages
- 36,581
- Likes received
- 3,172
- Thanks received
- 1,186
So having confirmed that the Bobs are treating you with the respect you seem to deserve here is the noddy code you need.
Code:CREATE OR REPLACE PROCEDURE ADD_LOCATION ( (sTEST_DATA IN NVARCHAR2, iTEST_ID OUT INTEGER) AS BEGIN INSERT INTO TEST_DATA VALUES (seqTestData.nextval, sTEST_DATA ); SELECT seqTestData.CURRVAL INTO iTEST_ID FROM DUAL; END
Personally, I'd do the fetch into the variable before the insert. Generally because I like to include audit and debug statements like "About to insert record ID x" before the insert.
Code:
CREATE OR REPLACE PROCEDURE sp_AddTestData (sTEST_DATA IN NVARCHAR2, iTEST_ID OUT INTEGER) AS
BEGIN
SELECT seqTestData.NEXTVAL INTO iTEST_ID FROM DUAL;
INSERT INTO TEST_DATA VALUES (iTEST_ID, sTEST_DATA );
END;
But the overall impact is the same

