Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL help needed
BSI wrote:
> Hi there,
>
> I have a problem and hope somebody may be able to help. Compiling the
> following code, i get "PLS-00363: expression 'SELF' cannot be used as an
> assignment target." Since i'm new to PL/SQL, I believe i must be missing
> something fundamentally wrong in calling methods. I've looked over the
> documentation, but couldn't find a solution.
>
> If it matters at all, I'm using Oracle Database 9.2
>
>
>
> CREATE OR REPLACE TYPE Proc AS OBJECT (
> anAttribute NUMBER,
>
> MEMBER FUNCTION FindBLY(aIndex OUT NUMBER, aStartIndex IN NUMBER)
> RETURN NUMBER,
> MEMBER PROCEDURE PrepareSegment(aIndex IN NUMBER)
>
> )
> /
> SHOW ERRORS;
>
> CREATE OR REPLACE TYPE BODY Proc
> AS
>
> MEMBER FUNCTION FindBLY(aIndex OUT NUMBER, aStartIndex IN NUMBER)
> RETURN NUMBER
> IS
> aValue NUMBER;
> BEGIN
>
> PrepareSegment( aValue );
> RETURN aValue;
>
> END;
>
> MEMBER PROCEDURE PrepareSegment( aIndex IN NUMBER )
> IS
> ycoord NUMBER;
> BEGIN
>
> --ycoord := FindBLY(ycoord, 1);
> DBMS_OUTPUT.PUT_LINE('aIndex is: ' || aIndex);
>
> END;
>
> END;
> /
> SHOW ERRORS;
>
>
> Please help :)
>
> Thanks.
What is the point of the member procedure? I get the feeling this is not the actual code.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Sat Apr 02 2005 - 09:24:46 CST