PLS-00103: Encountered the symbol "(" when expecti

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
rajaameet
Posts: 4
Joined: Sat Jan 17, 2009 2:49 am
Location: Pakistan

PLS-00103: Encountered the symbol "(" when expecti

Post by rajaameet »

CREATE OR REPLACE FUNCTION F_CONVERSION_RATE(V_RECEIPT_NUM IN VARCHAR2(30),V_ITEM_ID IN NUMBER,V_ORG_ID IN NUMBER)
return number is
V_CONVERSION_RATE number(8,6);

CURSOR C_CONV_RATE
IS
select distinct muc.CONVERSION_RATE
from rcv_transactioons rt, rcv_shipment_headers rsh,rcv_shipment_lines rsl, mtl_uom_conversions muc
where rt.SHIPMENT_HEADER_ID = rsh.SHIPMENT_HEADER_ID
and muc.UNIT_OF_MEASURE = rt.UNIT_OF_MEASURE
and rt.SHIPMENT_LINE_ID = rsl.SHIPMENT_LINE_ID
and rsh.RECEIPT_NUM = V_RECEIPT_NUM
and rt.ORGANIZATION_ID = V_ORG_ID
and rsl.ITEM_ID = V_ITEM_ID
and rt.TRANSACTION_TYPE = 'DELIVER';

begin

OPEN C_CONV_RATE;
FETCH C_CONV_RATE INTO V_CONVERSION_RATE;

CLOSE C_CONV_RATE;
RETURN V_CONVERSION_RATE;

exception when no_data_found then
return 1;
END;


when i create function then i got warnning and i get this error
PLS-00103: Encountered the symbol "(" when expecting one of the following: := . ) , [@] % default character The symbol ":=" was substituted for "(" to continue.

so someone help and guide me.
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest