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

From: <rob_at_oraclewizard.com>
Date: Fri, 13 Nov 2015 14:15:07 +0000
Message-ID: <W2404631525164931447424107_at_atl4webmail19>

This is a delete statment from a package I was asked to fix and tune (there are many opportunities for tuning this statement but thats out of the scope of this question.) ddocname is a column in the table reta_month defined at varchar2(100) shr_month is a table with the column ddocname defined as varchar2(100)  DELETE
 FROM shr_month
 WHERE ddocname IN
 (
 SELECT ddocname
 FROM mcu_metadata
 WHERE formtype ='SHR'
 AND packagename = i_vc_package_ddocname  )
 AND
 (
 DATA_YEAR, MONTH_NUM, AGENCY_ID
 )
 NOT IN
 (
 SELECT agency_id
 , data_year
 , month_num
 FROM reta_month
 WHERE data_home='C'
AND ddocname LIKE SUBSTR(shr_month.ddocname, 1, 14) || '%'  )
 AND data_home='H';

---

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 _at_navonpilot
youtube https://www.youtube.com/user/n4281k blog: http://www.oraclewizard.com
-----Original Message-----
From: Kim Berg Hansen [mailto:kibeha_at_gmail.com] Sent: Friday, November 13, 2015 08:51 AM To: rob_at_oraclewizard.com
Cc: 'ORACLE-L'
Subject: Re: Warning(2653,58): PLW-07202: bind type would result in conversion away from column type

Hi, Rob

Since the exception mentions binds, do you have a PL/SQL variable called ddocname? Or a PL/SQL record or object called shr_month with a member ddocname? Or your SQL statement is within a function/procedure called shr_month with a local variable called ddocname? Or some other constellation so that some of what you think is a table column in the SQL statement actually is a PL/SQL variable bound into the statement?

Otherwise I can't see why you would get a PLW exception about binds?

Regards

Kim Berg Hansen

http://www.kibeha.dk
kibeha_at_kibeha.dk
_at_kibeha

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 13 2015 - 15:15:07 CET