| 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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
