Help with database

[gReaen]

Hello, I'm trying to connect Oracle database with HTML frontend using JSP. I tried displaying contents of a table but it shows the contents even after i delete them from the table. Can someone help please? I'm new to this. Also, i need to insert 500 chars of data. Tried varchar2 and long datatype but my oracle shows it should be under 241 chars. What should i do? I use Oracle 9i.

[Paul Conrad]

gReaen wrote:

I tried displaying contents of a table but it shows the contents even after i delete them from the table.

Sounds like you either have to refresh the table or commit the changes to the database.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

[gReaen]

I tried deleting it directly from the table. It clearly shows that there are zero rows in the table but, the webpage still displays it. Is there any alternatives to reflect that change on the webpage?

[Vasudevan Deepak Kumar]

Two reasons: 1) Commit Changes After Deleting Rows 2) Page being displayed from cache

Vasudevan Deepak Kumar Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson