How to generate a report in D2K when the data is stored in ISCII format?
Ans.: This is report which calls ismapi32.dll on client side thru reports. It uses oracle foreign function interface package. This package is also available in forms. Sample file (RDF file) is available here . GistPackage: (pkgSpec) PACKAGE GistPackage IS FUNCTION ConvertingFunction(isciistr VARCHAR2) RETURN VARCHAR;/* declarations*/ END; ————————————– GistPackage: (pkgBody) PACKAGE BODY GistPackage IS mathlib_lhandle Ora_Ffi.Libhandletype; to_power_fhandle Ora_Ffi.Funchandletype; FUNCTION ff_to_isfoc(fhandle Ora_Ffi.Funchandletype,isciistr in VARCHAR2, isfocstr IN OUT varchar,datalen IN NUMBER,scriptName IN VARCHAR2) RETURN NUMBER; /* parameters to iscii2isfoc isciistr = sting to be converted isfocstr= string initially spaces (to be filled) datalen= length of iscii scriptName= kind of conversion to be formed DVB= devanagari, GJB= gujarati, etc. This may also be passed as a parameter for more flexibility */ PRAGMA interface(C, ff_to_isfoc, 11265); FUNCTION Conv
