Reset sequence in workflow or mapping
785062Aug 27 2010 — edited Aug 30 2010I tried by simply creating procedure and inserting it in the workflow. but i get the following error:
RPE-01003: An infrastructure condition prevented the request from completing.RPE-01038: Failed to evaluate expression declare l_expression VARCHAR2(4000) := SEQ_TRADE;begin :result := owbsys.wb_rt_conversions.from_char(l_expression);end;. Please modify the expression, redeploy and retry again.ORA-06550: line 1, column 42:
PLS-00357: Table,View Or Sequence reference 'SEQ_TRADE' not allowed in this context
ORA-06550: line 1, column 24:
PL/SQL: Item ignored
ORA-06550: line 1, column 107:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 1, column 61:
PL/SQL: Statement ignored
the procedure is simple and it works fine when executed from toad:
CREATE OR REPLACE PROCEDURE DWH."RESET_SEQS" (seq_name IN VARCHAR2)
IS
BEGIN
EXECUTE IMMEDIATE 'DROP SEQUENCE DWH.'||seq_name;
EXECUTE IMMEDIATE 'CREATE SEQUENCE DWH.'||seq_name||
' START WITH 1
MAXVALUE 999999999999999999999999999
MINVALUE 1
NOCYCLE
NOCACHE
NOORDER';
END;
Any suggestions? Tx