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
Messages: 1
Registered: January 2009
Location: MUMBAI
Junior Member


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 .

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

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: Tue Oct 25 14:41:45 CDT 2016

Total time taken to generate the page: 0.10102 seconds