Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL error
PL/SQL error [message #252762] Thu, 19 July 2007 22:03 Go to next message
npadilla
Messages: 9
Registered: July 2007
Junior Member
Good day,
I cant seem to trouble shoot this...
I have this line in my stored procedure, when i compiled it, i got the following error messages.

medium_name := replace((medium_name,',','","')||'"');
medium_name := trim(''''||medium_name||'''');


Line # = 12 Column # = 3 Error Text = PLS-00363: expression 'MEDIUM_NAME' cannot be used as an assignment target
Line # = 12 Column # = 3 Error Text = PL/SQL: Statement ignored
Line # = 13 Column # = 3 Error Text = PLS-00363: expression 'MEDIUM_NAME' cannot be used as an assignment target
Line # = 13 Column # = 3 Error Text = PL/SQL: Statement ignored

Can someone help me pls?
Thanks

Re: PL/SQL error [message #252766 is a reply to message #252762] Thu, 19 July 2007 22:29 Go to previous message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
>Can someone help me pls?
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/toc.htm
Please RTFM & help yourself.

http://asktom.oracle.com -- has many, many fine coding examples
Previous Topic: Max 30 date
Next Topic: cross tab query for last 12 months data
Goto Forum:
  


Current Time: Tue Dec 06 14:25:34 CST 2016

Total time taken to generate the page: 0.11991 seconds