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


[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

Original text of this message