Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00363 expression cannot be used as an assignment target

592323Jun 4 2008 — edited Jun 4 2008
Hi ,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2008
Added on Jun 4 2008
1 comment
2,999 views