You are here:

Oracle/CREATE VIEW USING PROCEDURE OR VIEW

Advertisement


nikhil wrote at 2016-09-10 06:15:37
Dear sir



   i have create the below procedure to create view within procedure and its executing successfully but while fetching

data from view its showing invalid number



create or replace

PROCEDURE ADMIN.VIEWFORLOOP(batchno1 varchar2,medidn1 varchar2

)

IS



BEGIN





EXECUTE IMMEDIATE 'CREATE OR replace view ADMIN.TEMPTRACKINGREPORT AS (

select TEMPTRACN.*,ROWNUM N from admin.TEMPTRACN  where  

medid     = '||medidn1||' and   batchno  ='||batchno1||')';



END ;


Oracle

All Answers


Answers by Expert:


Ask Experts

Volunteer


Suchitra Joshi

Expertise

I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader, Oracle Forms, Oracle Reports, and some basic dba and performance tuning activities.

Experience

15+ years of Oracle PL/SQL Development

Education/Credentials
B.Sc (Electronics), Diploma in Computer Applications (DCA)

Awards and Honors
Oracle PL/SQL Developer Certified Associate (OCA)
Oracle Database: SQL Certified Expert
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000

©2016 About.com. All rights reserved.