This discussion is archived
13 Replies Latest reply: Mar 11, 2013 2:38 AM by Tonito99 RSS

Master detail form issue retrieving service price automatically

Tonito99 Newbie
Currently Being Moderated

I developed a master detail form in order to process service requests.

On details block I'm trying to retrieve automatically service price after I select service name from LOV.

For this purpose I created a application plsql process


v_price service.price%type;

select     price into v_price
from      service
where      service_no = 1;

exception when others then htp.prn('An error occurred retrieving the PRICE');


Which process I'm calling through javascript function in order to retrieve service price.

<script type="text/javascript">

function GetServicePrice(pThis)
var vRow ='_')+1);
html_GetElement('f07_'+vRow).value = new htmldb_Get(null,html_GetElement('pFlowId').value,'APPLICATION_PROCESS=getPrice',0);


Instead of price it returns this value: "[object Object]".
Is it possible to work as I intended or it should other way around?

I appreciate your help/comments.

Application Express
Oracle Database 11g Express Edition Release



  • Correct Answers - 10 points
  • Helpful Answers - 5 points