search

timithy3 / jqgrid-for-plsql

Automatically exported from code.google.com/p/jqgrid-for-plsql
0 stars 0 forks source link

Trouble installing schema objects using install.sql #3

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1.  Running @install.sql from sqlplus prompt connected as schema owner
2.
3.

What is the expected output? What do you see instead?

What I see:

SQL> @install.sql
create type t_str_array as table of varchar2(4000);
            *
ERROR at line 1:
ORA-00955: name is already used by an existing object

create type t_date_array as table of date;
            *
ERROR at line 1:
ORA-00955: name is already used by an existing object

create type t_num_array as table of number;
            *
ERROR at line 1:
ORA-00955: name is already used by an existing object

Warning: Type created with compilation errors.

Enter value for quot:

---- this is where i quit.  Don't even know what to enter for quote

What version of the product are you using? On what operating system?

Latest version.

Apex 4, Oracle 11.1.0.6 RHEL 5 x86-64

Please provide any additional information below.

Original issue reported on code.google.com by tinad...@gmail.com on 20 Aug 2010 at 11:20

GoogleCodeExporter commented 8 years ago 
Make sure the install script is run with "set define off;" at the start of the 
script.

Original comment by thehunge...@gmail.com on 22 May 2012 at 8:59