Home » RDBMS Server » Server Administration » SELECT statements work, INSERT doesn't.
SELECT statements work, INSERT doesn't. [message #373776] Tue, 08 May 2001 02:10 Go to next message
Happosai
Messages: 1
Registered: May 2001
Junior Member
Hi!

I'm currently building a program for browsing and altering data in an Oracle database. The problem is, I can browse the database easily, all the SELECT statements work, but I can't add anything to the database. When I'm sending an INSERT INTO statement, Oracle answers with a null string and no data gets transferred.

Here's the type of query I used:
INSERT INTO nameOfTheTable VALUES (1,'data','data');

The table was empty, but I checked with user_tab_columns, that all the columns existed.

Could this be a problem with the syntax or do I need some new privileges for the user?

Thanks!

Report message to a moderator

Re: SELECT statements work, INSERT doesn't. [message #373777 is a reply to message #373776] Tue, 08 May 2001 02:37 Go to previous message
satish
Messages: 112
Registered: September 2000
Senior Member
How u are inserting into the table.
Can you be specific ? like from java or directly.
then Whether are u doing for all the columns in the table.

Report message to a moderator

Previous Topic: LOBS
Next Topic: Duplicates users - fuzzy!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 00:11:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.