Re: [Q] CREATE USER via Forms V4.0?

bpearc1_at_abacus.tis.tandy.com (Byron Pearce) wrote:
>
> I am trying to create a DB Admin tool via SQL*Forms V4.0 that will
> help maintain database accounts. However, when I try and execute
> the 'CREATE USER :B_block.username;' syntax within a PL/SQL procedure
> it fails to compile. Even hard-coding a name (i.e. 'CREATE USER jdoe1;')
> does not work.
>
> I am at a loss (being a DBA and not a SQL*Forms designer). Can you not
> execute SQL syntax from within a SQL*Forms procedure or am I just
> missing something? Any help is greatly appreciated.
>
> ==============================================================================
> Byron Pearce | The thoughts and views herein do not
> Tandy Information Services | necessarily reflect that of Tandy
> byron.pearce_at_tandy.com | Corporation.
> ------------------------------------------------------------------------------
> "It's hard to be a ninja when you wear a beeper."
> ==============================================================================
>
>

Hello Byron !

You cannot use a DDL statement direct in SQL*Forms40, but there is a builtin procedure FORMS_DDL. With this procedure you can do what you want.

br, Mike Received on Sat Jan 07 1995 - 15:54:24 CET