Dynamic SQL
From: Eric Veilleux - Ers <eveilleu_at_ers.ca>
Date: 1997/12/29
Message-ID: <6890re$5gc$1_at_cti15.citenet.net>#1/1
Date: 1997/12/29
Message-ID: <6890re$5gc$1_at_cti15.citenet.net>#1/1
[Quoted] I've made a form that let me navigate in the all_objects view in order to see the tables, triggers, sequences and indexes, it works pretty good execept that I wanted to be able to create new objects and drop new objects.
I'm having a hard time doing so. I figured I could put the sql statment into a varchar2 and then execute it (like in pro*c) but that dosen't work, how could I execute something like this?
sql_stmt varchar2(200) := 'drop ' || :all_objects.object_type || ' ' || :all_objects.object_name
Eric Veilleux
eveilleu_at_ers.ca
Received on Mon Dec 29 1997 - 00:00:00 CET