Re: dbms_sql.parse

CHRIS MCDEVITT wrote:
>
> CREATE or REPLACE PROCEDURE make_preimm_view
> ( this_provider IN person.primary_provider%TYPE) IS
>
> c1 INTEGER;
> rc INTEGER;
> str1 VARCHAR2(800);
>
> BEGIN
> str1 := 'CREATE OR REPLACE VIEW test as select * from providers; ';
> c1 := dbms_sql.open_cursor;
> dbms_sql.parse(c1,str1,dbms_sql.native);
> rc := dbms_sql.execute(c1);
> dbms_sql.close_cursor(c1);
> END;
> ==========================
> Chris,

I don't believe you need to add the ";" within the string parameter.

Wayne

Go Gators!! Received on Tue Jan 23 1996 - 18:59:23 CST