If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

Hi,
Thanks in advance.
Please help me I am passing the variables from the web browser to the UNIX by clicking the button my browser. But question is the variables which I am passing are not passing to the UNIX. The following are the variables I am declared p_new_proj_id and p_upd_proj_id.

Please answer me

Thanks for the info but my problem is now I am passing the values from the WEB. Means the user is entering the values on the browser and I am capturing the values in to these two variables p_new_proj_id and P_upd_proj_id and I am passing the variables directly to sqlrun stream which is calling my procedure and it is supposed to take the values but some how its not taking the variables which I am passing from the web browser.

As per ur answer I have to create the values on my procedure but its not possible because user enters the values and those values has to go directly to the variables which I declared on the procedure like the following update statement.

We are using Oracle Web Application Server and I wanted to send these variablles to the UNIX machine.
Now I am connecting to the oracle successfully with out any problem the following code i am using now

The quesion is how do I pass the variables from Out side to the UNIX because now its upadating with the set variable but its not giving the value of the variable. like as I mentioned I am passing the user id and password and its connecting to the sql with out any problem

The code you have now is using open to fetch run_sql and adding a query string to it, but it looks like it might not be working correctly. Does it cause problems? It shouldn't hae spaces between the variables, or quotes around the variable names either. In any case, you just want to add the values to your query string, with something like