Orabind returns error "bind value too large for bindsi

[paul sorya]

Hi,

I’m trying to save a complete lab hl7 message as a field to an oracle table. The catch [… orabind ..] command returns this error :

“orabind: bind value MSH…(hl7 complete message body snipped)…  too large for bindsize”

I tried to search in this forum “orabind” but cannot find any related topics.

Has somebody experienced with this error before?

Is this error related to the oratcl configuration on my QDX engine?

What is the config file for oratcl and where in the config file should I modifiy to increase the bindsize?

Any suggestions/helps will be gratefully appreciated.

Thanks,

Paul Sorya

Systems Analyst

Centre Hospitalier de l’Universite de Montreal

Montreal, Quebec

Canada

Topic

[paul sorya]

Hi,

From the Web, I leaned that “oraconfig” command allows me to increase the size of the buffer for binding variable values up to the maximum of 4000 bytes.

With the maximum of 4000 bytes, my problem is not completly resolved.

Does somebody have the solution to overcome the maximum of 4000 bytes for biding variable values?

Thanks!

Paul Sorya

Systems Analyst

MD Center of Universite of Montreal

Montreal, Quebec

Canada

[paul sorya]

Hi All,

Finally I found the solution to my problem. Here is the summary of my solution:

1) The column that exceeds 4000 bytes must be converted to CLOB data type.

2) First, I insert  the raw to the table with the CLOB fields umpty using orapase/orabind/oraexec commands.

2) Then, I update the CLOB columns with oralob-alloc and oralob-write  commands.

Thanks,

Paul Sorya.

[Author]

Replies