try typing "commit" after your delete -- you must commit or transaction will
be rolled back once you leave your session.
"David" <david.wynter_at_btclick.com> wrote in message
news:CrLM7.82200$JZ3.231478_at_NewsReader...
> Hello,
>
> I am using 8.1.5 on W2K server. I have a Servlet connected to the database
> with the same login I am using for SQL Plus, GUI version. I prefer to use
> the SQL Plus command line version but I ahve never been able to connect to
> the database because of ORA-12560: TNS:protocol adapter error even thought
> the servlet is using the same TNS Listener with the same user id through
> JDBC?
>
> I use SQL Plus to delete a row ala
>
> <-----------------
> SQL> select field_name, rw_field_id, record_id from rw_field where
> field_name like 'New%';
>
> FIELD_NAME RW_FIELD_ID RECORD_ID
> -------------------------------------------------- ----------- ---------
> New MSCI Industrial Class Code 8993 161
>
> SQL> delete from rw_field where rw_field_id = 8993;
>
> 1 row deleted.
>
> SQL> select field_name, rw_field_id, record_id from rw_field where
> field_name like 'New%';
>
> no rows selected
>
> <-----------------
>
> I exit Sql Plus and the servlet and restart SQLPlus and the row has gone.
> But when I restart the servlet and look at the page that has a selector
for
> these records that row is still there, but I cannot select it with a
normal
> query in SQLPlus. My knowledge of Oracle is limited but this is too weird.
>
> Any explanations?
>
> Regards
>
> David
>
>
Received on Tue Nov 27 2001 - 09:28:21 CST
