Re: How to perform a Dynamic DDL transaction in a Pro*C program?

pass the ddl-statement you want to execute to a package in the database. There you can use dynamic SQL to execute the statement (see the server application developers guide or equivaltent for more documentation on dynamic sql)

On Wed, 23 Jan 2002 12:13:30 -0500, Cristian Palma <cristian.palma_at_sage.cl> wrote:

>I'm developing a program in Pro*C, and as a part of it, I need to
>perform a Dynamic DDL transaction, such as:
>
>alter tablespace TABLESPACE_NAME coalesce;
>
>and
>
>analyze table TABLE estimate statistics
>
>I tried using
>
>EXEC SQL ddl_statement
>
>but I doesn´t work. Oracle tells me that DDL statements aren´t
>supported inside EXEC SQL.
>
>Does anybody knows a functional way to execute DDL statements? EXECUTE .
>. END-EXEC;?
>
>
>Thanks in advance,
>
>Cristian Palma
Received on Thu Feb 07 2002 - 23:22:50 CET