Re: can't create table from package

On Dec 16, 7:56 am, DA Morgan <damor..._at_psoug.org> wrote:
> William Robertson wrote:
> > On Dec 15, 7:52 pm, "shakespeare" <what..._at_xs4all.nl> wrote:
>
> >> No, this is not
> >> CREATE SCHEMA
> >> but
> >> CREATE PROCEDURE "schema.procname"
>
> > I was responding to David Fitzjarrell's comment that "CREATE SCHEMA"
> > is available from 10g onwards.
>
> CREATE SCHEMA is listed in the Oracle 7 Server SQL Language Quick
> Reference (1987).

Indeed, it's on page 4-221 of http://download.oracle.com/docs/pdf/A32538_1.pdf (And check out the typo on page A-18)

The bit about being able to roll back multiple DDL has long been a source of wonder for me, begging the question of implicit commits on other DDL.

jg

--
@home.com is bogus.
"Some somehow observe the day,but are vexed, I believe, that the body
of people profane it, and blessed be God no authority yet compels them
to keep it." - Boston Puritan Samuel Sewall, Christmas Day 1685 - when
celebrating Christmas was illegal in New England