Home » Developer & Programmer » Reports & Discoverer » DISCOVERER 10G report function not diplaying the data. (DISCOVERER 10G)
DISCOVERER 10G report function not diplaying the data. [message #380509] Mon, 12 January 2009 02:48
mahidharit
Messages: 1
Registered: January 2009
Location: MUMBAI
Junior Member

HI ALL,

i am using one price API 'QP_PREQ_PUB.PRICE_REQUEST' in my function get_unit_price_test to get the price for the perticular item and quntity .quntity when i am using that function in annonymous block it is showing properly .but when i am using in that function in normal select statement it is showing null values.

i know that one reason is if we use API(which has DML statements ) it will not fetch the data in select stament .

declare
v_price number;
begin
i:=get_unit_price_test('33731L-100',50000000);
-- '33731L-100' is item name (Segment1),50000000 quantity.
dbms_output.put_line('v_price = '|| i);
end;

can u anybody help me to get the price using API in select statement in any another way??

select get_unit_price_test('33731L-100',50000000) from dual;




Previous Topic: Format Mask to currency
Next Topic: can't connect to Oracle Application Database by Discoverer Admin
Goto Forum:
  


Current Time: Wed Dec 04 19:38:20 CST 2024