Skip to Content
avatar image
Former Member

cl_sql_blob_ora throwing error with xls file

I cannot get an xls into an oracle 12 database. The demo ADBC_DEMO_LOBS_ORA works, but when I upload the attached xls (couldn't upload it, but any xls will do), it fails. Any help would be appreciated.

Steps to recreate:

I copied ADBC_DEMO_LOBS_ORA into zADBC_DEMO_LOBS_ORA.

I added this code below SPAN { font-family: "Courier New"; font-size: 10pt; color: #000000; background: #FFFFFF; } .L0S33 { color: #4DA619; } .L0S55 { color: #800080; }

xstr = '0202020202'.

SPAN { font-family: "Courier New"; font-size: 10pt; color: #000000; background: #FFFFFF; } .L0S31 { font-style: italic; color: #808080; } .L0S32 { color: #3399FF; } .L0S33 { color: #4DA619; } .L0S52 { color: #0000FF; } .L0S55 { color: #800080; } .L0S70 { color: #808080; }


DATA BUFFER TYPE XSTRING.
DATA: gt_bin_data TYPE STANDARD TABLE OF char1024.
DATA: gd_file_length TYPE i.
data: head type xstring.
CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
filename = 'C:\temp\Book1.xls'
FILETYPE = 'BIN'
IMPORTING
FILELENGTH = gd_file_length
HEADER = head
TABLES
data_tab = gt_bin_data
EXCEPTIONS
FILE_OPEN_ERROR = 1
FILE_READ_ERROR = 2
NO_BATCH = 3
GUI_REFUSE_FILETRANSFER = 4
INVALID_TYPE = 5
NO_AUTHORITY = 6
UNKNOWN_ERROR = 7
BAD_DATA_FORMAT = 8
HEADER_NOT_ALLOWED = 9
SEPARATOR_NOT_ALLOWED = 10
HEADER_TOO_LONG = 11
UNKNOWN_DP_ERROR = 12
ACCESS_DENIED = 13
DP_OUT_OF_MEMORY = 14
DISK_FULL = 15
DP_TIMEOUT = 16
OTHERS = 17.


CALL FUNCTION 'SCMS_BINARY_TO_XSTRING'
EXPORTING
INPUT_LENGTH = gd_file_length
IMPORTING
BUFFER = BUFFER
TABLES
BINARY_TAB = gt_bin_data
* EXCEPTIONS
* FAILED = 1
* OTHERS = 2
.
IF SY-SUBRC <> 0.
exit.
ENDIF.
xstr = buffer.

This was in the trace file:

*** ERROR => copy_input_values: invalid LOB locator handle 4, cnt=4, len=20, type=DBSL_DATA_BLOB bsloci.c 10460] {root-id=005056BE1B301EE6BEC1931ACA6390B4}_{conn-id=00000000000000000000000000000000}_0 Dump statement cache (rc=2=DBSL_ERR_ARG): sc_p=0x6dfe4d8,no=187,idc_p=(nil),con=1,act=1,slen=47,smax=1024,#vars=3,stmt=0x7291060,table=DBMS_LOB.WRITEAPPEND Dumping stmt. cache (DBSL private attributes): sch=x6dfe4d8, scp=x6e0d520, ups_sch=NULL, stp=x7b0bd90, r_c=0 prep=0, dbds=1, lit_cnt=0, lob_cnt=0, fae_cnt=0, xop=0, dbcount=0 IN : col_cnt=3, row_max=1, row_xcnt=0, row_pcnt=0, row_i=140733193388032, row_total=0, row_upto=4294967295, row_size=32516, vda_max=64, bound=1, itp=x74cf710, vda_arr=x7961e70 lob_anz=1, lob_max=4, lob_pw=0, lobarr=x7231f10, rows_ret=0 OUT: col_cnt=1, row_max=126, row_xcnt=0, row_pcnt=0, row_i=140505560121344, row_total=1, row_upto=0, row_size=512, vda_max=128, bound=0, itp=NULL, vda_arr=x76edf80 lob_anz=0, lob_max=0, lob_pw=0, lobarr=NULL, rows_ret=0 BEGIN DBMS_LOB.WRITEAPPEND (:A0,:A1,:A2) ; END;; Dumping stmt. token sequence: # type name len value 0: 0 = TEXT 6 'BEGIN ' 1: 0 = TEXT 20 'DBMS_LOB.WRITEAPPEND' 2: 0 = TEXT 1 '(' 3: 2 = MARKER(0) 0 NULL 4: 0 = TEXT 1 ',' 5: 2 = MARKER(1) 0 NULL 6: 0 = TEXT 1 ',' 7: 2 = MARKER(2) 0 NULL 8: 0 = TEXT 1 ')' 9: 0 = TEXT 6 '; END;' token_cnt=10, marker_cnt=3 cid=0, par=3, proc=DBMS_LOB.WRITEAPPEND head_p=0x7fff1ba2a380, cid=0: dbsl err=2=DBSL_ERR_ARG-> dbds err=2=DS_EXTERNALERROR,dbdsoci.c:1748 *** ERROR => ^^ Ds_exec_proc() -> err=2=DS_EXTERNALERROR bdsoci.c 1773] {root-id=005056BE1B301EE6BEC1931ACA6390B4}_{conn-id=00000000000000000000000000000000}_0

Any Help is appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers