var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How do i get seq.nextval from within a pl/sql function
Im using Oracle 9i and writing a PL/SQL function and i need to get the sequence.nextval within the function. I am getting an error saying sequence does not exist. I have tryed the following :
but I still get the same error message. Is there any way to get the next value in a sequence from within a PL/SQL function.
Any help would be greatly appreciated.
CREATE SEQUENCE myseq;
CREATE OR REPLACE FUNCTION fun_seq
SELECT fun_seq FROM DUAL;
Thanks. I dont need to create a sequence because the sequence that I am using (mySeq) already exists on the database.
Figured it out. It was a permissions issue.