PLS-00363 expression cannot be used as an assignment target
592323Jun 4 2008 — edited Jun 4 2008Hi ,
There is an issue with one of the function i converted from MS Server function into an Oracle function.This function is called by means of a procedure by passing the arguments(name and a value).
The function structure is like below
CREATE OR REPLACE FUNCTION functionname
(
v_Name IN VARCHAR2,
v_Type IN CHAR
)
RETURN VARCHAR2
AS
v_i NUMBER(10,0);
v_Output VARCHAR2(50);
BEGIN
v_Name := LTRIM(RTRIM(v_Name));
......................................................
.......................................................
......................................................
END;
But the error received is
expression v_Name cannot be used as an assignment target .I need to pass the two arguments into function from procedure.
can anyone help me on this