[TD3.1] DBP_ORAUSELOB and stored procedures

General discussion forum about all things older Team Developer versions.
Also version independent Q&A can be placed here.
nortonex
Poland
Posts: 1
Joined: 04 Apr 2018, 07:54
Location: Poland

[TD3.1] DBP_ORAUSELOB and stored procedures

Post by nortonex » 05 Jun 2018, 07:25

Hello everyone,
not a long time ago we were converting long raws into blobs in our Oracle database. We've run into a problem how to deal with blobs in TD3.1 - fortunately we've found DBP_ORAUSELOB parameter which enables to use blobs.
Now there's a big problem with executing stored procedures - when we run procedure outside package everything is working fine, but when procedure is stored inside package then executing it results an error: ORA-01024: invalid datatype in OCI call. I have no idea, how to deal with it.

Here is sample code:

Code: Select all

Form Window: frm1
	Contents
		Pushbutton: pb1
			Message Actions
				On SAM_Click
					Call SqlConnect( hSql )
					Call SqlSetParameterAll( hSql, DBP_ORAUSELOB, TRUE, '', TRUE )
					Call SqlPLSQLCommand( hSql, "testproc(1,df1)" ) ! procedure outside package <- works
					Call SqlPLSQLCommand( hSql, "testpkg.testproc2(1,df1)" ) ! the same procedure inside package <- doesn't work - ORA-01024: invalid datatype in OCI call
					Call SqlSetParameterAll( hSql, DBP_ORAUSELOB, FALSE, '', TRUE )
					Call SqlPLSQLCommand( hSql, "testproc(1,df1)" ) ! procedure outside package <- works
					Call SqlPLSQLCommand( hSql, "testpkg.testproc2(1,df1)" ) ! the same procedure inside package <- works
		Data Field: df1
			Message Actions
	Functions
	Window Parameters
	Window Variables
	Message Actions
		On SAM_CreateComplete
			Set df1 = 'some text'
The testproc and testproc2 procedures are doing nothing and have one number parameter and one string parameter.

Anyone can help?

Return to “General Discussion”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests