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...
Please ask this in the General Database[^] forum instead.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith
As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.