Re: Dynamic SQL

[Quoted] You need to use either DBMS_SQL or FORMS_DDL. If you ever need to execute a dynamic select you'll have to use DBMS_SQL. FORMS_DDL can't return anything. DBMS_SQL is kind of tricky to use from within forms. If you need further help you can Email me direct.

Steve J.

Eric Veilleux - Ers wrote:
>
> 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 Tue Dec 30 1997 - 00:00:00 CET