Please update your forum profile with a recognisable username instead of "user6341615".
i started to develop a program with oracle apex 18.2 and a database 11g i created a database USER_BADR and a sequence named USER_BADR_SEQ but when i create new user by my program an error occur:
ORA-06550: line 3, column 27: PLS-00302: component 'USER_BADR_SEQ' must be declared ORA-06550: line 3, column 27: PL/SQL: ORA-02289: sequence does not exist ORA-06550: line 3, column 9: PL/SQL: SQL Statement ignored.
the code of process get_pk is :
begin if :P6_USER_ID is null then select "#OWNER#"."USER_BADR_SEQ".nextval into :P6_USER_ID from sys.dual; end if; end;
Where is this process used and why is it necessary?
What schema owns the USER_BADR_SEQ sequence?
What is the parsing schema of the application?