Warning(2653,58): PLW-07202: bind type would result in conversion away from column type

  • From: rob@xxxxxxxxxxxxxxxx
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 13 Nov 2015 13:39:43 +0000


I'm trying to understand this warning a little better.
Warning(2653,58): PLW-07202: bind type would result in conversion away from
column typeWhen I look at the line kicking the warning it's a but confusing:
AND ddocname LIKE SUBSTR(shr_month.ddocname, 1, 14) || '%'
ddocname is defined as a varchar2(100) and substring will return a string. What
am I missing? Google has not been much help on this one.
-Rob


===================================

Robert P. LockardOracle ACEPresident Oraclewizard.com, Inc.
"When given the choice between two evils, I always take the one I have not
tried." Mae West
(cell) 571.276.4790
(office) 410.766.6960
(fax) 410.766.0332
twitter @navonpilot
youtube https://www.youtube.com/user/n4281k
blog: http://www.oraclewizard.com

Other related posts: