Provide the query which is used to add the users in the ARUDSUSER table.
Release : 9.1
Component : AuthMinder(Arcot WebFort)
Below is the query used to add the users in the ARUDSUSER table.
****************************************************************************************
INSERT INTO ARUDSUSER
( USERREFID, USERID, ORGNAME, STATUS, TELEPHONENUMBER,
EMAILADDR, FNAME, MNAME, LNAME, PAM,
PAMURL, IMAGE, INFOLIST, INTERNALATTR1, INTERNALATTR2, INTERNALATTR3, DATECREATED,
DATEMODIFIED )
VALUES
( #userRefID:INTEGER#,#userID:VARCHAR: #, #orgName:VARCHAR: #, #status#, #telephoneNumber:VARCHAR: #,
#emailAddr:VARCHAR: #, #fName:VARCHAR: #, #mName:VARCHAR: #, #lName:VARCHAR: #,
#pam:VARCHAR: #, #pamURL:VARCHAR: #, #image:VARBINARY: #, #infoList:VARCHAR: #,
#internalAttr1:VARCHAR: #, #internalAttr2:VARCHAR: #, #internalAttr3:VARCHAR: #, #dateCreated#, #dateModified# )
*****************************************************************************************
This is the query for the sequence creation -
============================================================
create sequence ARUDSUSERREFIDSEQ
start with 1
increment by 1
cache 20;
create or replace
procedure sequenceNextVal(seq_id in varchar2, ref_id out integer)
as
begin
select ARUDSUSERREFIDSEQ.NEXTVAL into ref_id from dual;
end sequenceNextVal;
======================================================