Return structure from DLL to PL/SQL

From: Peter Valencic <peterv_at_in2.si>
Date: 28 Mar 2002 06:49:51 -0800
Message-ID: <16290d4d.0203280649.579d0b3b_at_posting.google.com>

I have a function in DLL which return a pointer to a C Structure. How can I register such function in pl/sql?

C structure is like this:

typedef struct IHISD_HPC_DO {

	IHISD_ALPHANUM	title;			/* length = 1 .. 7	*/
	IHISD_ALPHANUM	surname;		/* length = 2 .. 24	*/
	IHISD_ALPHANUM	forename;		/* length = 2 .. 24	*/
	IHISD_ALPHANUM	country_code;		/* length = 2 fixed	*/
	IHISD_NUMERIC 	health_insurance_no;	/* length = 9 fixed	*/
	IHISD_NUMERIC 	card_instance_no;	/* length = 1 .. 2	*/
	IHISD_NUMERIC 	id_number;		/* length = 5 fixed	*/
	IHISD_NUMERIC 	profession;		/* length = 2 fixed	*/
	IHISD_NUMERIC 	specialization;		/* length = 2 fixed	*/
	IHISD_ALPHANUM 	hcs_country;		/* length = 2 fixed	*/
	IHISD_NUMERIC 	hcs_id;			/* length = 5 fixed	*/
	IHISD_ALPHANUM 	hcs_name;		/* length = 2 .. 25	*/
	IHISD_BCD 	hcs_role;		/* length = 2 fixed	*/

} IHISD_HPC_DO;

---

I have read Oracle documentation, but only type of variables are: varchar,pls_integer,number,binary_integer... (look ORA_FFI paackage)

Please help...

The DLL function is like this:
 long myFunction (int number,int *xx,IHISD_HPC_DO *datas)

how to register such function????
I don't have source code of DLL !!!

please for help

best regards
peter Received on Thu Mar 28 2002 - 15:49:51 CET