odc icon indicating copy to clipboard operation
odc copied to clipboard

[Bug]: calling procedure get SQLException 'No output result'

Open LuckyPickleZZ opened this issue 2 years ago • 2 comments

ODC version

4.2.2

OB version

4.2.1

What happened?

please use this sql.txt to prepare schema.

sql.txt

When calling the PRC_11_CD_AD_CO_DEPS use obclient, it would work normally. But when calling it on ODC4.2.2, you may get a SQLException 'No output result'.

Noted this error only occurs on OB 4.2.x. It could work normally on 3.x.

What did you expect to happen?

successfully

How can we reproduce it (as minimally and precisely as possible)?

⬆️

Anything else we need to know?

No response

Cloud

No response

LuckyPickleZZ avatar Nov 30 '23 05:11 LuckyPickleZZ

There may be a jdbc bug. After I set jdbc param sendConnectionAttributes to true, this worked normally.

LuckyPickleZZ avatar Dec 11 '23 12:12 LuckyPickleZZ

Ob-jdbc2.4.8 version have fixed this problem

zijiacj avatar Mar 26 '24 14:03 zijiacj

Image pass

sl01388797 avatar Sep 19 '24 08:09 sl01388797