Re: How to use in Stored procedure

From: Jim Lyons <jlyons_at_weblyons.com>
Date: 13 Feb 2003 14:28:34 -0800
Message-ID: <e67857c9.0302131428.73cd471a@posting.google.com>

sunnycal_98_at_yahoo.com (sunnycal_98_at_yahoo.com) wrote in message news:<9c592ada.0302121435.7b32f100_at_posting.google.com>...
> Hi,
> I have executed the following statement and want to get help using
> them in Oracle Stored Procedure.
>
>
> Create sequence do_id start with 1;
>
> create or replace procedure getid as is id number;

I'd be surprised if you create a sequence in a store procedure, unless you use dynamic SQL. You can't perform DDL in PL/SQL.

Jim Lyons
DBA
University of Texas at Austin Received on Thu Feb 13 2003 - 16:28:34 CST