Process not found error !! [message #449565] |
Tue, 30 March 2010 09:21 |
BBMamun
Messages: 94 Registered: February 2010 Location: Dhaka, Bangladesh
|
Member |
|
|
Hi I have made a simple page to show details of a department using Ajax As follows:
A select list Item p15_dept Contains Dname from Dept Table. The idea is to populate a Text Area Named p15_detail when select a dname from the list.
Application Process Name= getDetail
Source:
DECLARE
my_det VARCHAR2 (200);
BEGIN
SELECT deptno || CHR (10) || dname || CHR (10) || loc
INTO my_det
FROM dept
WHERE deptno = :p15_dept;
HTP.prn (my_det);
EXCEPTION
WHEN OTHERS
THEN
HTP.prn ('');
END;
error message set to
Process error
--------------------------------------------
Javascript Code written at HTML Header is as follows:
Please notice Application process part
<script language="JavaScript" type="text/javascript">
function f_getDet ()
{
var get = new htmldb_Get(null,&APP_ID.,'APPLICATION_PROCESS=getDetail',0);
get.add('P15_DEPT',html_GetElement('P15_DEPT').value)
gReturn = get.get();
if(gReturn)
{ html_GetElement('P15_DETAIL').value=gReturn }
else
{ html_GetElement('P15_DETAIL').value = '' }
get = null;
}
</script>
----------
HTML Form Element attribute for p15_dept is
onChange="f_getDet()"
----------
I run the form page but the at the Text Area p15_detail the message is Process not Found.
I know the system cannot find the application process but see no problem in my Javascript, So what can be the problem?? Please help.
Regards
Hasan Al Mamun
|
|
|
|