Re: Stored Proc help

Hi Deon,

There's a good PL/SQL book by Steve Feurstein (don't quote me on the spelling of his name) that would help you with a lot of questions. It's not impossible to create a table, you just have to use different syntax for DDL statements . If you have 8i, explore the EXECUTE IMMEDIATE syntax. If an earlier version, look at DBMS_SQL to handle it.

Hope this helps,

Steve

VR Deon wrote:

> I am fairly new to Oracle and have worked mainly in MS Sql. In stead of
> posting millions of questions on this site, I would prefer if someone could
> direct me to a good site for information. I am mainly involved in writing
> stored procedures and triggers for a database.
>
> Currently I am struggling to create a stored procedure that creates and
> manipulates data in a table. It does not seem to be possible to create a
> table within a SP, is this true and what could I have a look at to try and
> get a workaround?
>
> Thanks
> Deon
Received on Tue Apr 24 2001 - 07:37:51 CDT