Need help on database call

[appkel]

This is my task: there is a check box on a form. When a user checks the box, it will call a javascript function to call a oracle procedure to update the oracle database. it will happen background, that is no form repainted.

I don’t know how to call a oracle procedure in javascreipt.

Any ideas on how to do it are appreciated.

[PunkSktBrdr01]

Since JavaScript is a client-side language, it cannot connect to any databases. You'll need a server-side language, such as PHP, ASP, CF, or Perl.

[appkel]

Actually I am using Oracle Web Toolkit (htp, htf) stuff and oracle web application server. using javascripts to do certain things that oracle cannot do.

I can call oracle procedures in javascript, something like:
'parent.location.href = "oracleprocedurename.frameset(pageURL)"; '. Problem is that it will repaint the form. Can I call an oracle procedure in javascript but not to repaint the form?

[PunkSktBrdr01]

Well, the example code you posted, 'parent.location.href = "oracleprocedurename.frameset(pageURL)"; ', redirects to a different page. This means that the page will be reloaded, and there is no way to prevent this. (that I know of...)