I have one Report. In Report I use stored procedure
--=================================================
create or replace procedure pSalRPayHospitals(
p_iHospID in Integer,
--''---''----''
--''---''----''
p_rResult in out pkgSal.t_rCursor
) is
v_vCalcTypeName varchar2(55);
--''---''----''
--''---''----''
v_vEMHolidCoeffTxt varchar2(255) := '';
--===============================================
begin
-------------------------------
-------------------------------
-------------------------------
open p_rResult for
select p_iHospID as SalHospID,
--''--''--''--''
--''--''--''--''
v_vEMHolidCoeffTxt as HospCoeffs
from dual;
end pSalRPayHospitals;
--============================= End ==============================
If length of field "HospCoeffs" is more 32 characters
then this field is as null in report
(in this case I lose information in Report).
If length is <= 32 then All is OK
What can I do to normal work of my report???
This field I can't definition in input parameters my StoredProcedure, I fill him only in Stored procedure
Thanks in advance
splender@mail.ru
--=================================================
create or replace procedure pSalRPayHospitals(
p_iHospID in Integer,
--''---''----''
--''---''----''
p_rResult in out pkgSal.t_rCursor
) is
v_vCalcTypeName varchar2(55);
--''---''----''
--''---''----''
v_vEMHolidCoeffTxt varchar2(255) := '';
--===============================================
begin
-------------------------------
-------------------------------
-------------------------------
open p_rResult for
select p_iHospID as SalHospID,
--''--''--''--''
--''--''--''--''
v_vEMHolidCoeffTxt as HospCoeffs
from dual;
end pSalRPayHospitals;
--============================= End ==============================
If length of field "HospCoeffs" is more 32 characters
then this field is as null in report
(in this case I lose information in Report).
If length is <= 32 then All is OK
What can I do to normal work of my report???
This field I can't definition in input parameters my StoredProcedure, I fill him only in Stored procedure
Thanks in advance
splender@mail.ru