Re: Some questions Oracle (SQL)

Use either DBMS_SQL package ( for Oracle 7.x/ 8.0 ) or NATIVE DYNAMIC  SQL ( when using 8i ).

 HTH. Michael.

In article <8bb5cq$ghn$1_at_nnrp1.deja.com>,   rhillebrand_at_starren.nl wrote:
> Hello,
> Some questions about oracle :
> How to create a stored procedure to create a Table with a variable.
> Example :
> CREATE PROCEDURE UPCREATETABLE(varTable VARCHAR2) AS
> BEGIN
> CREATE TABLE varTable(...);
> END;
> How to create a stored procedure insert into a Table with a variable :
> Example :
> CREATE PROCEDURE UPINSERTDATA(varTable VARCHAR2, varValue as NUMBER)
 AS
> BEGIN
> INSERT INTO varTable VALUES (varValue)
> END;
> Is this possible ?
> R. Hillebrand
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Apr 12 2000 - 00:00:00 CDT