Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle Forms OLE2.invoke_char

Status
Not open for further replies.

xyzzMarkus

Programmer
Oct 1, 2002
1
AT
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(n);
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??
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top