Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Process not found error !! (Apex 3.2.1)
Process not found error !! [message #449565] Tue, 30 March 2010 09:21 Go to next message
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








Re: Process not found error !! [message #449679 is a reply to message #449565] Wed, 31 March 2010 07:24 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
The process name is case sensitive - make sure that the spelling and case match.
Previous Topic: Tabular Form with Ajax
Next Topic: Combobox in edit mode ?
Goto Forum:
  


Current Time: Wed May 23 23:31:05 CDT 2018