Re: javascript and pl/sql

As far as I know, the only way you can get from javascript to pl/sql is by doing a submit or executing a link. Essentually you are calling a pl/sql program on the application server. this program then takes the parameters you sent, in a post or get, does what ever processing you coded it to do, wraps the results in HTML and sends it back as a new web page for the browser to render. I don't think that this is quite what you are wanting to do but your description of what you want was not very clear to me so I am not sure.
You could do what you want by having your javascript pass the data to a java applet running in your browser. The java applet could then make a connection to the server and invoke a pl/sql procedure which could return data back to the applet and the applet hand the data back to javascript. The user never has to leave the web page. This is a rather elaborate way to go about it. Maybe somebody else has a better way. I suggest you go to www.experts-exchange.com and submit your question there. good luck
----- Original Message -----
From: "Sandy" <daleelaNOdaSPAM_at_usa.net.invalid> Newsgroups: comp.databases.oracle.tools
Sent: Wednesday, July 19, 2000 12:23 AM
Subject: Re: javascript and pl/sql

> Hi,
>
>
> In fact I would like to test the values entered in my form
> for this I have to look in a table to check if two values
> of my forms are in it and get in this table two values that
> i will need to check others text areas in my form. For
> this, I could like to call my pl/sql procedure in
> javascript code with two parameters which are both
> document.form.namesomething.value and get two values that i
> will use in my javascript function to test the others and
> all this without changing the url for the user of the site.
>
>
> If you didn't understand something you can ask me and if
> you think your idea can help could you please give it to me
> in detail thanks a lot
>
> Sandy
>
>
Received on Thu Jul 20 2000 - 00:00:00 CEST