At 11:27 PM 5/03/2003 -0300, you wrote:

>Ivan,
>
>
> >SQL distinguishes between DDL and DML.
> >Because stored procedure is DML command
> >and creating table is DDL command, how would you classify
> >stored procedure with DDL command inside ?
> >PHL (Professional Hybrid Language) ? :-)
>
>Therefore, Oracle and SQL server supports PHL :-)

Erm....you would be strongly advised to check that out before you part with
any money. The following are the statement headers that are supported by
Oracle P/L:

SELECT
INSERT
UPDATE
DELETE
COMMIT
ROLLBACK
SET CONSTRAINTS
SET ROLE
SET TRANSACTION
SAVEPOINT
LOCK TABLE

There are some differences with Fb's PSQL (Oracle and MSSQL Server support
embedded transactions, Fb doesn't). Oracle can treat constraints and roles
as run-time variables; Fb does not require explicit locks on tables...

But one thing Fb and Oracle P/Ls do have in common is that they do NOT
permit you to issue DDL from a stored procedure.

MSSQL *does* let you create tables in SPs, which should be thought of as a
necessity born of inferior architecture and language implementation, rather
than as "more professional".

Because you seem convinced that Oracle *does* support DDL in SPs (when it
certainly doesn't) I'm starting to suspect that you don't understand the
difference between a DDL script and a stored procedure...

heLen