Pro*C: Precompilation Of Code Executing DBMS_HS_PASSTHROUGH Package On Remote Non-Oracle DB Using DBLINKS Fails With Segmentation Fault When SQLCHECK=FULL (Doc ID 1091131.1)

Last updated on JANUARY 23, 2013

Applies to:

Precompilers - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Jan-2013***

Symptoms

Precompilation of code executing DBMS_HS_PASSTHROUGH package on remote non-Oracle DB using DBLINKS fails with segmentation fault when SQLCHECK=FULL

Failing code:

#include <stdio.h>
#include <string.h>
#include <stdlib.h>
#include <sqlda.h>
#include <sqlcpr.h>


typedef unsigned int TYPE_uint4byte;

/******************************************************************************/
/* MAIN PROGRAM */
/******************************************************************************/
main(argc, argv)
int argc;
char *argv[];
{
int ret_code;



EXEC SQL BEGIN DECLARE SECTION;
TYPE_uint4byte Orali_crs;
VARCHAR sqlstmt[2000];
EXEC SQL END DECLARE SECTION;



EXEC SQL EXECUTE
BEGIN
:Orali_crs := DBMS_HS_PASSTHROUGH.OPEN_CURSOR@sybase_dg4odbc;
DBMS_HS_PASSTHROUGH.PARSE@sybase_dg4odbc(:Orali_crs,:sqlstmt);
END;
END-EXEC;
}

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms