xyzzMarkus
Programmer
I have a Form which writes in Excel 2002 and I must find out the Decimal separator and the country code.
I Try this with following code but I get the Error that the International Methode was not executeable.
procedure get_separator is
v_separator varchar2(4000);
n number; x varchar2(4000);
--wert_char varchar2(4000) := null;
wert_num number :=null;
begin
args := ole2.create_arglist;
OLE2.ADD_ARG(args,3);
melde('vor aufruf');
v_separator := OLE2.invoke_char(application,'International',args);
--xlcountrycode =1;
--xldecimalseparator =3
OLE2.DESTROY_ARGLIST(args);
melde(v_Separator);
exception
when others then
melde(sqlerrm);
n := OLE2.LAST_EXCEPTION (x);
melde;
melde(x);
end;
Has anyone an Idea why it doesn't work or has anyone another idea how i can get programaticle to the Decimal seperator and the country code??
I Try this with following code but I get the Error that the International Methode was not executeable.
procedure get_separator is
v_separator varchar2(4000);
n number; x varchar2(4000);
--wert_char varchar2(4000) := null;
wert_num number :=null;
begin
args := ole2.create_arglist;
OLE2.ADD_ARG(args,3);
melde('vor aufruf');
v_separator := OLE2.invoke_char(application,'International',args);
--xlcountrycode =1;
--xldecimalseparator =3
OLE2.DESTROY_ARGLIST(args);
melde(v_Separator);
exception
when others then
melde(sqlerrm);
n := OLE2.LAST_EXCEPTION (x);
melde;
melde(x);
end;
Has anyone an Idea why it doesn't work or has anyone another idea how i can get programaticle to the Decimal seperator and the country code??