NDS = Native Dynamic SQL.

Actually, however, you don't need either. My bad - you don't have any dynamic SQL.

You should just use the returning clause in your case:

Code:
CREATE OR REPLACE PROCEDURE   
GET_NEXT_NUMBER_REFERENCE   
(
   IN_REQUESTED_TYPE IN OUT   CHAR,   
   OUT_RESULT_OUT    IN OUT   NUMBER
)   AS
BEGIN

   UPDATE
      NUMBER_REFERENCE   
   SET
      BIG_SEQUENCE_NBR   =   BIG_SEQUENCE_NBR + 1
   WHERE
      RECORD_ID   =   IN_REQUESTED_TYPE
   RETURNING
      BIG_SEQUENCE_NBR
   INTO   
      OUT_RESULT_OUT   ;

   COMMIT;   
END GET_NEXT_NUMBER_REFERENCE;
HTH,

- Chris