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>
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_lnameReceived on Mon Mar 03 2008 - 10:08:30 CST
%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;