Home » SQL & PL/SQL » Client Tools » SQL Developer issue
SQL Developer issue [message #170018] Mon, 01 May 2006 13:53 Go to next message
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.
Re: SQL Developer issue [message #170032 is a reply to message #170018] Mon, 01 May 2006 15:38 Go to previous messageGo to next message
Littlefoot
Messages: 21578
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
Re: SQL Developer issue [message #170038 is a reply to message #170032] Mon, 01 May 2006 16:10 Go to previous message
florida
Messages: 82
Registered: April 2006
Member
No I did not commit. It now works.

Thanks!!

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


Current Time: Tue Aug 04 14:45:23 CDT 2020