 Oracle OWB 11g Process Flow : While Loop is not working [message #496099] |
Thu, 24 February 2011 08:05 |
sourajit_seth
Messages: 38
Registered: November 2005
Location: India
|
Member |
|
|
Hi ,
I am recently developing Oracle process Flow in 11g and don't know the exact syntax how
to provide the condition in WHILE loop , thus getting error
I am getting the following problem :
i) I have defined two variables
G_loop ( Integer) assigned value to 0
G_limit ( Integer) assigned value to 7
<< I want to run the loop for 7 times >>
ii) I have defined While Loop ( as well as END loop)
iii) The nodes between WHILE and END LOOP are "ASSIGN" and "OWB MAPPING" . Another node is
present
which is EXIT of WHILE loop.
IN the condiiton of the While loop I mentioned as
==> G_loop < G_limit
In the "ASSIGN" node, I assigned the value ( G_Loop + 1 ) to the Variable G_loop
< i.e. G_loop will be incremented by 1 for every loop >
The process flow is deploed successfully, but getting the runtime error as follows :
i) RPE -01003 : an infrastructure condtiton prevented the request from completing
ii) RPE - 01038
iii) "<Process Name>");end if;return "WHILE LOOP";end;begin: result:= "<Process Name>";end
;Please modify the expression , redeploy and try again
iv) ORA-06550; Line 1 , COlumn 3808 ; PLS 00103 : Enconterted the symbol "&" when expecting
one of the follloiwng () -+ case mode new not null <an identifier > < a douboe-quoted
delimited identifier> < a bind variable > ...
It seems there is a problem in the syntax of WHILE LOOP . Please advise.
Thanks in advance
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
