Oracle query
-
I have a storedprocedure in oracle,in that am using begin OPEN RCT1 FOR SELECT REPLACE(SelectStatus.SelectCommand, '@Location', SelectStatus.Location) INTO SelectStatus.SelectCommand FROM DUAL; end; My output is :- Select * from area_master where location = '001' order by area_name what is want is instead of getting this query as output,i want the result of this query as output.. how can i execute this query inside the SP?... Any help will be appreciated thanks in advance...
-
I have a storedprocedure in oracle,in that am using begin OPEN RCT1 FOR SELECT REPLACE(SelectStatus.SelectCommand, '@Location', SelectStatus.Location) INTO SelectStatus.SelectCommand FROM DUAL; end; My output is :- Select * from area_master where location = '001' order by area_name what is want is instead of getting this query as output,i want the result of this query as output.. how can i execute this query inside the SP?... Any help will be appreciated thanks in advance...