Home » Developer & Programmer » Warehouse Builder » Oracle OWB 11g Process Flow : While Loop is not working (OWB 11g)
icon9.gif  Oracle OWB 11g Process Flow : While Loop is not working [message #496099] Thu, 24 February 2011 08:05
Messages: 38
Registered: November 2005
Location: India
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

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

Previous Topic: Creating Data
Next Topic: OWB Repository creation error
Goto Forum:

Current Time: Sat Jul 30 06:21:21 CDT 2016

Total time taken to generate the page: 0.19641 seconds