Orcacle PlSql & USELOB -> malfunction

[holger.mueller]

 Posted by:  Holger Mueller, CSD 

SqlWindows/32 3.1 PTF 4, Oracle 9i/10i, sqlora32.dll

SQL.INI: USELOB=1

Try follwing action:

SqlConnect ( hSql )

Set isClientInfo = sP_ClientInfo
If Not SqlOraPLSQLPrepare ( ihSqlMain, 'BEGIN
DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:isClientInfo);END;' )
Return FALSE
If Not SqlOraPLSQLExecute ( ihSqlMain )
Return FALSE

=> PlSqlError (iteration, invalid length of bind)

Workaround:

Call SqlSetParameterAll ( hSql, DBP_ORAUSELOB, 0, "", TRUE )

Then calling again PLSql, no error returns

There are some other errors while inserting in VARCHAR2(4000)-all theses
errors will disapear when calling SqlSetParameterAll ( hSql,
DBP_ORAUSELOB, 0, "", TRUE )at startup.

Thx

Holger Mueller, CSD Vienna

[Denys Motornyy]

 Posted by:  Denys Motornyy 


Are You try select more than 53 column in one select? (look at my post "No
result set" error" in this group)

How You set up enviroment for get working SqlSetParameter function? (look at
my post "Oracle LOB" in conectivity forum)

--
Denys Motornyy