use variable object name in Oracle procedures

From: Liang Lin <llin_at_med.umich.edu>
Date: 16 Nov 1993 15:17:39 GMT
Message-ID: <2caquj$1nl_at_terminator.rs.itd.umich.edu>


I have a procedure like this:

create procedure test(view_name varchar2) as  begin
.......

  create view view_name as ......
.......

 end;

Is there any way to cheat Oracle so that it will regard view_name as an object_name instead of a character string?

Liang Lin

Internal Medicine Network Service                   llin_at_med.umich.edu
University of Michigan Medical Center							(313) 936-8305
Received on Tue Nov 16 1993 - 16:17:39 CET

Original text of this message