newbie syntax question

From: brock wade <brockuswade_at_yahoo.com>
Date: Mon, 3 Mar 2008 08:08:30 -0800 (PST)
Message-ID: <c602ec7c-41e4-4e17-87e6-ec78a32f8869@n58g2000hsf.googlegroups.com>


Thanks to anyone with any clues here as to what could be wrong with my code, I'm totally new to Oracle!

In my Oracle Package Body (Package compiles fine) I'm getting an error on this line of code saying: "ORA-02289: sequence does not exist":

               select usr_id_s1.nextval into pUSER_id from dual;

Here is the complete stored procedure:

Procedure UserSecurityAdd(pUSER_login in users_t1.usr_login
%type,

                 pUSER_lname                 in users_t1.usr_lname

%type,
pUSER_fname in users_t1.usr_fname
%type,
pUSER_mi in users_t1.usr_mi%type, pUSER_pcd_view in users_t1.usr_pcd_view
%type,
pUSER_emp_id in users_t1.usr_emp_id
%type,
pRowsAffected out number) is begin select usr_id_s1.nextval into pUSER_id from dual; insert into users_t1 ( usr_emp_id, usr_login, usr_lname, usr_fname, usr_mi, usr_pcd_view) values ( pUSER_emp_id, pUSER_login, pUSER_lname, pUSER_fname, pUSER_mi, pUSER_pcd_view); commit; pRowsAffected := sql%rowcount; end UserSecurityAdd;
Received on Mon Mar 03 2008 - 10:08:30 CST

Original text of this message