313: PROCEDURE get_answer_id(
314: answer_id OUT NoCopy NUMBER)
315: IS
316: BEGIN 317: SELECT msc_answers_s.nextval 318: INTO answer_id
319: FROM sys.dual;
320:
321: return;
Line 347: INSERT INTO MSC_ANSWERS(
343: ans IN VARCHAR2)
344: IS
345: BEGIN
346: -- dbms_output.put_line('Inserting answer:'|| ans); 347: INSERT INTO MSC_ANSWERS( 348: ANSWER_ID,
349: QUESTION_ID,
350: SEQ_NUM,
351: SESSION_ID,