I have created a procedure to pass in a value (eg: student ID) and an OUT variable from the procedure storing Yes/No to indicate if the student ID exist in the database or not.
if (document.forms.elements[i].name ==
v_student_id = document.forms.elements[i].value;
alert(v_student_id ||' '|| v_valid);
One alternative way would be calling through a html form.
form's action field specifies the procedure to execute, and the named input elements on the HTML form pass parameters
and then the pl/sql procedure is run.
Last edited by hrishy; 08-24-2005 at 06:30 AM.
Thanks for your reply! I have been searching in the net but could nto find any answers to this issue!
Anyway, is there any alternatives that you would suggest?
You cna do that in the stored procedure and if the value already exists then the stored proc can actually write out a html page back to the client saying there is a error.
You get the idea ?
Click Here to Expand Forum to Full Width