insertion for a table - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

insertion for a table

Author

Topic

rajasekhar857
Constraint Violating Yak Guru

396 Posts

Posted - 2009-06-01 : 02:36:25

hi i am having a table with more than 10 columns in it.
now i have created a view with three columns from it.
sp_help emrscreenimmunlkup

SCREEN_IMMUN_ID NOT NULL NUMBER(20)
RECORD_TYPE NOT NULL VARCHAR2(2)
GENDER NOT NULL NUMBER(20)
SUB_GENDER NUMBER(20)
DESCRIPTION NOT NULL VARCHAR2(500)
STARTING_AGE_OPERATOR NOT NULL VARCHAR2(255)
STARTING_AGE_VALUE NUMBER(20)
STARTING_AGE_UNITS VARCHAR2(255)
FREQUENCY VARCHAR2(500)
STARTING_AGE_LIMIT_RANGE NUMBER(20)
STARTING_AGE_LIMIT_UNITS VARCHAR2(255)
AGE_END_LIMIT NUMBER(20)
AGE_END_LIMIT_UNITS VARCHAR2(255)
REPEAT NUMBER
REPEAT_AGE_VALUE NUMBER(20)
REPEAT_AGE_UNITS VARCHAR2(255)
FREQUENCY_LIMIT NUMBER(20)
REPEAT_CONDITION VARCHAR2(255)
GROUP_ID NUMBER(20)
STATUS NUMBER(1)
CDC_CODE VARCHAR2(50)
SCREEN_COMMENTS VARCHAR2(255)
MASTER_REFERENCE_ID NUMBER(20)

sp_help v1(view)

SCREEN_IMMUN_ID NUMBER
GROUP_ID NUMBER
MASTER_REFERENCE_ID NUMBER

insert into emrscreenimmunlkup (screen_immun_id,group_id, master_reference_id) select screen_immun_id,group_id, master_reference_id from v1

exception:

insert into emrscreenimmunlkup (screen_immun_id,group_id, master_reference_id) select screen_immun_id,group_id, master_reference_id from v1
Error report:
SQL Error: ORA-01400: cannot insert NULL into ("ABC"."EMRSCREENIMMUNLKUP"."RECORD_TYPE")
01400. 00000 - "cannot insert NULL into (%s)"
*Cause:
*Action:

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-06-01 : 02:40:23