DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2001

    PLS-00363: expression 'P_RET_CD' cannot be used as an assignment target

    I do nut understand why I am getting the above error messages.

    Within my package body, I have a whole hoist of procedures which are passed in parameters (as IN OUT) they are also initialised in the executable section and are assigned others values within processing.

    Can someone help???

  2. #2
    Join Date
    Jan 2002
    Up s**t creek
    Can you post a sample of the code where the error is occuring?
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Oct 2001



    I have a procedure(s) which take in the follwoing parameters

    p_ret_cd IN OUT NUMBER,
    p_ret_msg IN OUT VARCHAR2

    Then in the Begin section these are initialised

    p_ret_cd := 0;
    p_ret_msg := 'OK';

    Then this procedure is called within the same package body as the procedure above and p_dops_record('INSERT', p_ret_cd, p_ret_msg, v_idps_recin.sch_af_id); Note the first and the last parameters are just IN.

    When I try to compile the pakage body - I get the following errors

    PLS-00363: expression 'P_RET_CD' cannot be used as an assignment
    show errors
    p_ret_cd := 0;
    p_ret_msg := 'OK';
    p_dops_record('UPDATE', p_ret_cd, p_ret_msg, v_idps_recin.sch_af_id)
    p_ret_cd := -20110; NOTE it is re-assigned elsewhere in processing..

    When I Isolate the procedure in a package body and leave the IN OUT and call it from another procedure just like above - IT COMPILES!!

    Any idea???

  4. #4
    Join Date
    Oct 2001
    Problem sorted!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.