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

In article <3eicpp$5mu_at_abacus.tis.tandy.com>, Byron Pearce <bpearc1_at_abacus.tis.tandy.com> 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

1. Create user is DDL, not DML.
2. I do not think you can use DDL directly.
3. But you can use FORMS_DDL. Look at README.doc at your $ORACLE_HOME/forms40/doc for detail about DDL if you are not familar with it.
   >it fails to compile. Even hard-coding a name (i.e. 'CREATE USER jdoe1;')
   

Hope this help!
>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."
>==============================================================================
>
>
>
Received on Fri Jan 06 1995 - 23:43:51 CET