Insert long varchar data to Oracle 11g clob column

General discussion forum about all databases other than SqlBase.
shanalalkasim
India
Posts: 8
Joined: 22 Apr 2019, 11:39
Location: India

Insert long varchar data to Oracle 11g clob column

Post by shanalalkasim » 04 Sep 2010, 08:34

While insert SqlBase longvarchar data to Oracle DB through ODBC, an error saying "Missing long bind before write long" is created. I have used the following code:

Call SqlPrepare( hSqlODml, "
INSERT INTO JOB_ORDER ( JB_CODE, EQ_CODE, jo_report, jo_desc )
VALUES ( 111111, 2222, :lstrTempDesc , :lstrTempDesc ) " )
Call SqlSetLongBindDatatype( 3, 24 )
Call SqlSetLongBindDatatype( 4, 24 )
Call SqlExecute( hSqlODml )


Columns 3 & 4 are CLOBs and lstrTempDesc & lstrTempDesc are long string variables.

Sometimes it works fine if we give the CLOB columns as first binds in the Insert sql.

Thank you in advance for your help.
You do not have the required permissions to view the files attached to this post.

Jeff Luther

Re: Insert long varchar data to Oracle 11g clob column

Post by Jeff Luther » 09 Sep 2010, 01:10

I think that should be "23" not "24" in the bind call. 24's specifically for Informix. Try that.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 2 guests