OraFAQ Forum: Server Administration » SELECT statements work, INSERT doesn't.

Home » RDBMS Server » Server Administration » SELECT statements work, INSERT doesn't.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SELECT statements work, INSERT doesn't. [message #373776]

Tue, 08 May 2001 02:10

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 01:14:02 CST 2025