Re: can't create table from package

From: shakespeare <whatsin_at_xs4all.nl>
Date: Sat, 15 Dec 2007 20:52:58 +0100
Message-ID: <476430a3$0$85780$e4fe514c@news.xs4all.nl>

"William Robertson" <williamr2019_at_googlemail.com> schreef in bericht news:34f0ee7d-affc-4881-8068-90f51af222e6_at_s19g2000prg.googlegroups.com...
> On Dec 13, 2:03 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>
>> And with 10g and later releases there is CREATE SCHEMA, which would
>> preclude the use of PL/SQL to create database objects on product
>> installation, which creates all or nothing should an error occur.
>
> CREATE SCHEMA has been around since at least 7.3:
> <http://download.oracle.com/docs/cd/A57673_01/DOC/server/doc/SQL73/
> ch4a.htm#toc098>
>
> However it is arguably of limited usefulness:
> <http://radiofreetooting.blogspot.com/search?q=create+schema>

No, this is not
CREATE SCHEMA
but
CREATE PROCEDURE "schema.procname"

Shakespeare Received on Sat Dec 15 2007 - 13:52:58 CST