OraFAQ Forum: Client Tools » SQL Developer issue

Home » Other » Client Tools » SQL Developer issue

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

SQL Developer issue [message #170018]

Mon, 01 May 2006 13:53

florida
Messages: 82
Registered: April 2006

Member

I downloaded SQL Developer and SQL Plus to my Windows 2000 workstation.

I can connect to my Oracle 9i database with both using the same schema/login username.

The weird part is when I try and insert data using SQL Developer it doesnt show up in the database. After I do the insert statement it sometimes just hangs up.

But if I do an insert into a table using SQL Plus it works great.

Please advise. I must be doing something wrong with SQL Developer but I do see my 3 tables and all the records I inserted using SQL Plus. But cant insert info using SQL Developer.

Earlier today I actually did insert a record using SQL Developer but then later today I check and the record is not there and now I cant insert any data using the SQL Developer tool. Noboby else has touched my schema.

Please advise.

Report message to a moderator

Re: SQL Developer issue [message #170032 is a reply to message #170018]

Mon, 01 May 2006 15:38

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you COMMIT in SQL*Developer? If not, those records will not be seen in any other session than your current SQL*Developer session.

In other words:
Scenario A:
SQL Developer> insert into some_table values (some_values);
SQL*Plus> select * from some_table;
SQL*Plus> no rows selected

Scenario B:
SQL Developer> insert into some_table values (some_values);
SQL Developer> COMMIT;
SQL*Plus> select * from some_table;
SQL*Plus> values you inserted in SQL Developer session

Report message to a moderator

Re: SQL Developer issue [message #170038 is a reply to message #170032]

Mon, 01 May 2006 16:10

florida
Messages: 82
Registered: April 2006

Member

No I did not commit. It now works.

Thanks!!

Report message to a moderator

Previous Topic:	Connecting Toad with Oracle 10g
Next Topic:	isqlplus??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 21:08:58 CST 2024