How to use in Stored procedure

Hi,
I have executed the following statement and want to get help using them in Oracle Stored Procedure.

 Create sequence do_id start with 1;

 create or replace procedure getid as is id number;

 my question is how to use the sequence creation statement within the procedure and return the id back from stored procedure to calling programs.

thanks for the help.

Sunny Received on Wed Feb 12 2003 - 16:35:27 CST