Insert

[llunar]

I want to insert records to the table test1 from table prueba, for example
insert into test1
(fecha,momento,antes)
values
(select
fecha,momento from prueba);
when i runinng this script i was recived the following errors
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 8
ORA-00936: missing expression

[lipsa]

I want to insert records to the table test1 from table prueba, for example
insert into test1
(fecha,momento,antes)
values
(select
fecha,momento from prueba);
when i runinng this script i was recived the following errors
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 8
ORA-00936: missing expression

***********************
hey i m a beginner,3 months work exp,still trying
i think ur query should b something like this
insert into test1
(fecha,momento,antes)
select
fecha,momento,some_column from prueba;

u wanna insert into 3 columns and providing 2 values,and "values' keyword also wont b used
regards,
lipsa
*************************

[llunar]

Hey i don't understand your answer.

In this case explain me the similars errors

insert into cli_tab_19_old
(MOD_19_TAB_NUM_COD,
MOD_19_TAB_DES_NOR,
MOD_19_TAB_ESP_COD,
MOD_19_TAB_BAR_COD,
MOD_19_TAB_BAR_PRE,
MOD_19_TAB_REQ_DIA,
MOD_19_TAB_DIA_EST,
MOD_19_TAB_1ER_COD,
MOD_19_TAB_2DO_COD,
MOD_19_TAB_ANE_COD,
MOD_19_TAB_ESP_DES,
MOD_19_TAB_1ER_DES,
MOD_19_TAB_2DO_DES,
MOD_19_TAB_ANE_DES,
MOD_19_TAB_BAR_DES,
MOD_19_TAB_INT_COD)
values
(select
MOD_TAB_NUM_COD,
MOD_TAB_DES_NOR,
MOD_TAB_ESP_COD,
MOD_TAB_BAR_COD,
MOD_TAB_BAR_PRE,
MOD_TAB_REQ_DIA,
MOD_TAB_DIA_EST,
MOD_TAB_1ER_COD,
MOD_TAB_2DO_COD,
MOD_TAB_ANE_COD,
MOD_TAB_ESP_DES,
MOD_TAB_1ER_DES,
MOD_TAB_2DO_DES,
MOD_TAB_ANE_DES,
MOD_TAB_BAR_DES
from cli_tab_11_old);

Error on line 0
insert into cli_tab_19_old
(MOD_19_TAB_NUM_COD,
MOD_19_TAB_DES_NOR,
MOD_19_TA

ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 8
ORA-00936: missing expression

***********************
hey i m a beginner,3 months work exp,still trying
i think ur query should b something like this
insert into test1
(fecha,momento,antes)
select
fecha,momento,some_column from prueba;

u wanna insert into 3 columns and providing 2 values,and "values' keyword also wont b used
regards,
lipsa
*************************

[masdi2t]

actually we've 2 kind of INSERT statement

1. INSERT INTO <table> [(field)] VALUES (<values>)
2. INSERT INTO <table> [field] SELECT [field] FROM <table>

when we use INSERT ... SELECT, we can simply insert rows selected from another table or tables, while INSERT ... VALUES insert from constant value.

[lipsa]

Dear llunar,
plz check that ur 'MOD_19_TAB_INT_COD' column value(in the SELECT......) is not provided.and also dont use 'values' key word as masdi2t has already explained.
Regards
Lipsa :)

[aarbhargavi]

I want to insert records to the table test1 from table prueba, for example
insert into test1
(fecha,momento,antes)
values
(select
fecha,momento from prueba);
when i runinng this script i was recived the following errors
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 8
ORA-00936: missing expression

hai
have u checked u r table structure for column lengths.
because ora-00604 is an error that can be corrected if ora-06502 can be rectified.ora-06502 can be corrected if column data lengths are of suitable type.
usually this problem comes when u r trying to insert 10 charcters into a column whose data length is 5.
and ora-00936 is due to ur insert statement requires three columns for select stament where as u r select stament returns only two columns.and in insert from table type syntax the key word 'values' is not nessasary.

[amitpatel66]

I want to insert records to the table test1 from table prueba, for example
insert into test1
(fecha,momento,antes)
values
(select
fecha,momento from prueba);
when i runinng this script i was recived the following errors
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 8
ORA-00936: missing expression

There are two problems from your insert statement:

1. You want to insert 3 values, but in select statement you are selecting only 2 values.
2. When you use a SELECT statement with INSERT statement, the key word VALUE should not be used.

Correct these and try executing a query. Do post back in case of any further problem!!