Not sure what you are asking - is this not simply a warning message- as opposed to a compilation error?
Either way: the error message is clear. In you 'where' clause: If you are comparing different data types with one another, you could open yourself to 'sub-optimal query plan' (I.E: possible performance issues) Is there a reason you are trunc'ing date PLGT_TRN_DT? Are all the other 'where clause' comparisons comparing apples with apples. IE. number = number, char = char, not number = varchar. Not sure if that helps you much. On Sun, Nov 9, 2008 at 8:39 AM, Rahul <[EMAIL PROTECTED]> wrote: > > Hi All, > > Please help me. > > I create Procedure inside procedure i am using one cursor like below > > CURSOR C_DETAIL (P_CUR_PAC VARCHAR2,P_PLGT_TRN_TYP VARCHAR2) IS > SELECT > > PLGT_TRN_NB,PLGT_CUR_PAC_NB,PLGT_OTH_INST,PLGT_OTH_PAC_NB,PLGT_TRN_DT,PLGT_PLG_NB,PLGT_ESIS_TRN_NB,PLGT_STK_CD, > > > PLGT_TRN_QTY,PLGT_STS,PLGT_TRN_TYP,PLGT_REMARKS,PLGM_STS,PLGM_PLGT_STS,EACM_PAC_NB,EACM_PAC_ENAME > FROM PLGT,PLGM,EACM,CACM > WHERE PLGM_PLG_NB = PLGT_PLG_NB > AND PLGT_CUR_PAC_NB = EACM_PAC_NB > AND EACM_ACC_NB = CACM_ACC_NB > AND PLGT_CUR_PAC_NB = P_CUR_PAC > AND PLGT_TRN_TYP = P_PLGT_TRN_TYP > ** AND trunc(PLGT_TRN_DT) BETWEEN P_ST_TRN_DT AND > P_END_TRN_DT; > > after create procedure working fine. I try to create Package that time > coming below error > > PLW-07204: conversion away from column type may result in > sub-optimal query plan > > > Thanks > Rahul > > > > -- Michael Mann --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
