Re: View creation!!Please help!

From: Deepa Kamat <dkamat_at_questone.com>
Date: Thu, 30 Mar 2000 05:03:38 GMT
Message-ID: <KeBE4.14723$QJ3.2268921@dfiatx1-snr1.gtei.net>

Hi all,

    I tried using the DBMS_SQL package to execute the query .But, a new problem has arisen. After creating the procedure, when I try to execute it, it gives me the following error.ORA-01031: insufficient privileges

        Can anyone please tell me which priveleges are to be set ??
        Thanking u in anticipation.



CREATE OR REPLACE PROCEDURE try AS
  2      cursor1 INTEGER;
  3      str varchar(200);
  4       BEGIN

  5 str := 'create view pd_view as select pd_id, pd_parent, pd_hierarchy, pd_id_val,pd_parent_val
 from product';

  6        cursor1 := dbms_sql.open_cursor;
  7        dbms_sql.parse(cursor1,str, dbms_sql.v7);
  8        dbms_sql.close_cursor(cursor1);
  9      end;

 10 /

Procedure created.

execute try;
BEGIN try; END;

*
ERROR at line 1:

ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SYS_SQL", line 487
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at "SYSTEM.TRY", line 7
ORA-06512: at line 1

Thanks and Regards,
Deepa Received on Wed Mar 29 2000 - 23:03:38 CST