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
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
