Orcacle PlSql & USELOB -> malfunction

forum.gupta.bugreport (2005-2010)
holger.mueller
Austria
Posts: 198
Joined: 28 Aug 2017, 09:36
Location: Brunn am Gebirge, Austria

Orcacle PlSql & USELOB -> malfunction

Post by holger.mueller » 19 Oct 2005, 22:57

 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

Re: Orcacle PlSql & USELOB -> malfunction

Post by Denys Motornyy » 20 Oct 2005, 14:55

 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

Return to “gupta.bugreport”

Who is online

Users browsing this forum: No registered users and 0 guests