Hello Team!

question regarding export to Excel.

We use api_datasource.printtoexcel procedure to export the results of the dataset.

When we pass the Latin file name to the parameter - all goes smoothly (like "result.xls").

But when we try to pass the Russian one - we get a "zero" file name after export (the whole file name = "xls").

We did some debug and the value in Russian is being passed (it is not null).

The code we use for export (the version is still 1.6 for this installation):

 api_datasource.printtoexcel('V_FS_CNTRL_LIST_EXCEL1', vColumns, 'N',
    api_datasource.getColumnValueTX('ds_sb_cnfl_FS_UPL_FILES.FILE_NAME'),
    api_datasource.FILE_FORMAT_XLS);

Here are the NLS parameters:

NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET CL8MSWIN1251
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 11.2.0.4.0

What could you suggest to change or use as a workaround? Seems to be something simple like alter some session params.

Any ideas would be highly appreciated.

Thank you

asked 10 Apr, 05:46

anatoly4u's gravatar image

anatoly4u
6923
accept rate: 0%

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×9
×4
×4

Asked: 10 Apr, 05:46

Seen: 218 times

Last updated: 10 Apr, 05:46


© Copyright Gerger 2017