Firstly thnx for your quick reply. And could you suggest a way in which the above error could be corrected. Even tried logging in as user:system. But it did not help. Same error.
M
Mygrp
@Mygrp
Posts
-
Creating Table dynamically in Oracle 9i -
Creating Table dynamically in Oracle 9iSQL> create or replace procedure create_tablename(name varchar2) is 2 3 str varchar2(20) := name; 4 v_str varchar2(255); 5 Begin 6 v_str := 'Create table '||'AFR'||'_'||str||'(rollno NUMBER(2),name varchar2(10))'; 7 Execute immediate v_str; 8 End; 9 / Procedure created. SQL> variable abc varchar2(20) SQL> exec create_tablename(:abc); BEGIN create_tablename(:abc); END; * ERROR at line 1: ORA-01031: insufficient privileges ORA-06512: at "SCOTT.CREATE_TABLENAME", line 7 ORA-06512: at line 1 hey can any1 suggest what exactly the problem is? The above code is for creating the table dynamically in Oracle 9i....
-
Creating Table dynamically in Oracle 9iHey friends can anyone suggest the method for creating Table Dynamically in Oracle 9i.. Will b very Thankfull for ur Help..
-
Interfacing VC++ 6 and Matlab 7Can anyone tell me how to interface VC++ 6 and Matlab 7 I need it for my project...