Stack Overflow
Stack Overflow

Questions tagged [ora-00947]

11 questions
17
votes
1 answer

ORA-00947 Not enough values while declaring type globally

create table foo( id number, status varchar2(10) ); Table created. insert into foo values( 1, 'open' ); insert into foo values( 2, 'close' ); insert into foo values( 3, 'open' ); insert into foo values( 4, 'open' ); insert into foo values(…
Gaurav Soni
  • 6,278
  • 9
  • 52
  • 72
4
votes
2 answers

Oracle: INSERT values from SELECT...JOIN, SQL Error: ORA-00947: not enough values

I'm trying to do the following: INSERT INTO MyTable(a, b, c) SELECT a FROM source1 JOIN source2 ON ... Where source2 contains columns B and C. However Oracle doesn't seem to like this and is telling me "SQL Error: ORA-00947: not enough values". Am…
mszaro
  • 1,362
  • 1
  • 13
  • 25
2
votes
2 answers

ORA-00947 : Not Enough Values

I know this is a newbie question, but I really don't know what is wrong with my procedure, can anyone help me? CREATE OR REPLACE PROCEDURE PRC_COPIA_ITEM_LOCACAO IS TYPE TP_LOC_ITEM_BKP IS TABLE OF LOC_ITEM_LOCACAO%ROWTYPE; LOC_BKP…
Pelissonik
  • 31
  • 1
  • 1
  • 5
1
vote
1 answer

ORA-00947: not enough values but check the column already.

I've created a table as fllow: CREATE TABLE"COMMODITY" (COM_NO VARCHAR2(10) NOT NULL, COM_NAME VARCHAR2(100) NOT NULL, SHOP_NO VARCHAR2(10)NOT NULL, FRU_NO VARCHAR2(10)NOT NULL, COM_PRICE NUMBER(10)NOT NULL, COM_WEIGHT VARCHAR2(30)NOT…
Jun
  • 11
  • 1
1
vote
2 answers

ORA-00947 - not enough values: Occurs in one server but not another

I am work on a project which has to add one column to the exist table. It is like this: The OLD TBL Layout OldTbl( column1 number(1) not null, column2 number(1) not null ); SQL TO Create the New TBL create table NewTbl( column1 number(1) not…
MrIncrediable
  • 13
  • 1
  • 4
1
vote
1 answer

ORA-00947 : Not Enough Values while putting values into a type inside a procedure

I have created some Oracle types: create or replace TYPE "RESULTS_ADMIN" AS OBJECT ( ROWNUMBER NUMBER, ASSET_ID VARCHAR2(1000 CHAR), BOOK_ID VARCHAR2(10 CHAR), asset_name VARCHAR2(50 CHAR) , book_author VARCHAR2(30 CHAR) , …
Subhopriyo
  • 95
  • 1
  • 8
0
votes
3 answers

Showing PL/SQL ERROR : ORA-00947: not enough values

Please help me, how to fill in the correct values? Because the value is always less, and showing ERR not enough values the error is in here Here is my code : CREATE OR REPLACE TRIGGER REGION_HILMI_TRIGGER_WARNING AFTER INSERT OR UPDATE OR DELETE ON…
Hilmi Afifi
  • 13
  • 2
0
votes
1 answer

Not enough values when inserting a row in oracle

I'm trying to insert a row by selecting some datas from another table. insert into spb (id_barang,nama_barang,qty,lokasi_tujuan,lokasi_asal,waktu) values ((select…
Evan Setiawan
  • 1
  • 2
0
votes
2 answers

column not allowed here error in oracle SQL insert

Hi I am getting this error while trying to insert the INPUT parameter into error table CREATE OR REPLACE PROCEDURE consolidate_SI( primary_SI IN NUMBER, secondary_SI IN NUMBER ) IS v_primary_si number; v_secondary_si number; Begin …
Prakash
  • 17
  • 1
  • 7
0
votes
1 answer

apache camel sql component ORA-00947: not enough values

This is my Java DSL route: from("seda:singlePersonChannel") .log(LoggingLevel.INFO, "Person bean: ${body}") .process(new Processor() { @Override public void process(Exchange exchange) throws Exception { …
suitej
  • 99
  • 1
  • 11
0
votes
1 answer

Is it possible to insert a record with rowtype X into a table with rowtype Y?

I'm stuck with something really weird. Yesterday I was able to produce a procedure like this: create or replace PROCEDURE proc IS CURSOR CUR IS SELECT * FROM PROVA WHERE STATUS = 'X'; BEGIN FOR H IN CUR LOOP BEGIN INSERT…
Massimo
  • 692
  • 2
  • 11
  • 29