Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00363 problem..
PLS-00363 problem.. [message #203924] Thu, 16 November 2006 23:51 Go to next message
deepayan
Messages: 51
Registered: December 2005
Member
Dear Experts,

Im facing a problem. Please help me out to get rid of this.

I have created a request in apps which accepts two parameters.Essentially this is a PL/SQL procedure.Users can enter this two field or keep it blank.If they keep it blank then I want a praticular value to be assigned in this two fields.

I have find that when user keeps it blank then it passes NUll
so I have tried by using this statement :
V_FROMDATE := NVL(V_FROMDATE,'30-SEP-2005');
V_TODATE :=NVL(V_TODATE,to_char(SYSDATE,'DD-MON-YYYY'));

But its throwing PLS-00363:expression 'V_FROMDATE'cant be used as assignment target.

Thanks in advance...
Re: PLS-00363 problem.. [message #203927 is a reply to message #203924] Thu, 16 November 2006 23:58 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Since you didn't provide us with any code I have to guess some things here.

You cannot assign a value to an IN-parameter. To accomplish what you want you can
- use a default value for the two parameters. This will only work if the parameters are not explicitly used in the call with values NULL
- create a local variable l_FROMDATE and use that troughout your procedure.
l_fromdate := NVL(V_FROMDATE, to_date('30-SEP-2005'));
and use l_fromdate from there on instead of v_fromdate.

Re: PLS-00363 problem.. [message #203977 is a reply to message #203924] Fri, 17 November 2006 03:19 Go to previous message
deepayan
Messages: 51
Registered: December 2005
Member
thanks a lot Frank..
Previous Topic: Version Control for resources (tables, views, seqs,etc..) ?
Next Topic: conditional select
Goto Forum:
  


Current Time: Sun Dec 04 06:46:44 CST 2016

Total time taken to generate the page: 0.08695 seconds