Friday, 15 April 2011

oracle - oracle11g sql: Warning: Type created with compilation errors -


I am trying to create a SuperTemp customer service and subtype agent and supervisor, so when I try, they are built-in Suppose it runs in Oracle SQL: a message comes

Warning: Type created with compilation errors

What's wrong with the code below?

  Type or replace customer_s_type as the object (CSID number, CSNName varchar (15), CSST number) is not final; Create or change type supervisor type under type_s_type (title varchar (10)); Create or change type agent type with customer agent_type (title varchar (10)); Create Supervisor_type table supervisor (CONSTRAINT supervisor_PK primary key (CSID)); Create Agent_type table agent (CONSTRAINT agent_PK primary key (CSID)); Table customer_service (CSID number (10), CSST number (10), constraint supervisor_pk primary key (CSID));    

You can use the show errors in SQL * plus Or because you have shown six commands and the warning is about one of the first 3 (because it gives context), select SQL Developer, or user_errors to see error details. for ), and they look differently from the obstruction kept in the comments independently, it seems that the whole script is being mentioned as an order. It depends on your client settings, but you probably need to separate the command with a / so that they can execute them. Texture type can include the to PL / SQL; is not considered as a statement separator therefore:

  type or type as customer_s_type object (CSID number, CSN name varchar (15), cstip number) final No; Type or replace customer supervisor type customer_s_type (title varchar (10)); Type or replace agent_type under customer_s_type (title varchar (10)); / Supervisor-type table supervisor (Construct supervisor / PK primary key (CSID)); Create Agent_type table agent (CONSTRAINT agent_PK primary key (CSID)); Table Customer_Service (CSID Number (10), CSTip Number (10), Constraints create customer_service_pk Primary Key (CSID));    

No comments:

Post a Comment