|
|
Re: How to passing Records type in ORA_FFI.register_parameter ? [message #197090 is a reply to message #197076] |
Tue, 10 October 2006 00:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
robert7788
Messages: 6 Registered: October 2006
|
Junior Member |
|
|
I have readed the documentation for 73152_01 ,but i don't know
Record type register_parameter in ora_ffi package, ora_ffi.register_parameter only can follow type:
Ora_Ffi.Register_Parameter
Description Registers the argument type of the current argument of the specified
foreign function.
Syntax
PROCEDURE Ora_Ffi.Register_Parameter
(funcHandle funcHandleType,
cargtype PLS_INTEGER);
PROCEDURE Ora_Ffi.Register_Parameter
(funcHandle funcHandleType,
cargtype PLS_INTEGER,
plsargtype PLS_INTEGER);
Parameters
funcHandle A function handle returned by
Ora_Ffi.Register_Function or
Ora_Ffi.Find_Function.
cargtype The C datatype of the current argument to the
C foreign function being called. The value of
this argument may be one of the following
packaged constants:
C_CHAR Means char
C_CHAR_PTR Means char *
C_DOUBLE Means double
C_DOUBLE_PTR Means double *
C_FLOAT Means float
C_FLOAT_PTR Means float *
C_INT Means int
C_INT_PTR Means int *
C_LONG Means long
C_LONG_PTR Means long *
C_SHORT Means short
C_SHORT_PTR Means short *
C_VOID_PTR Means void *
plsargtype The corresponding PL/SQL argument type
(optional).
|
|
|
|
Re: How to passing Records type in ORA_FFI.register_parameter ? [message #197191 is a reply to message #197103] |
Tue, 10 October 2006 08:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
robert7788
Messages: 6 Registered: October 2006
|
Junior Member |
|
|
i im working in ora_ffi, but dont't register record type ,i have spended a lot of time (15days),i want to call crystal report in form6i and use the foreign function of DLL,the name of DLL is CRPE32.DLL ,the function name is PELogOnServer ,do you point me how to use it ?
Below crystal report sdk documentation (Legacy.chm):
PELogOnServer
Use PELogOnServer to logon to the specified server.
C Syntax
BOOL CRPE_API PELogOnServer (
const char FAR *dllName,
PELogOnInfo FAR *logOnInfo );
Parameters
dllName
Specifies a pointer to the name of the Crystal Reports DLL for the server or password protected non-SQL table to which you want to logon. (for example, "crdb_odbc.dll"). Note that the dllName must be enclosed in quotes. DLL names have the following naming convention: crdb_*.dll for standard (non-SQL) databases and for SQL/ODBC databases.
logOnInfo
Specifies a pointer to PELogOnInfo.
Returns
TRUE if the call is successful.
FALSE if the call fails.
PELogOnInfo
PELogOnInfo contains log on information that is used by PEGetNthTableLogOnInfo, PESetNthTableLogOnInfo, PELogOnServer, and PELogOffServer for logging on and off SQL and password-protected non-SQL databases.
C Syntax
typedef struct PELogOnInfo {
WORD StructSize;
char ServerName [PE_SERVERNAME_LEN];
char DatabaseName [PE_DATABASENAME_LEN];
char UserID [PE_USERID_LEN];
char Password [PE_PASSWORD_LEN];
} PELogOnInfo;
Members
StructSize
Specifies the size of the PELogOnInfo structure. Initialize this member to PE_SIZEOF_LOGON_INFO.
ServerName
Specifies the logon name for the server (of length PE_SERVERNAME_LEN = 128, NULL-terminated) used to create the report. See Remarks below.
DatabaseName
Specifies the database logon name (of length PE_DATABASENAME_LEN = 128, NULL-terminated) for the database used to create the report. See Remarks below.
UserID
Specifies the user I.D (of length PE_USERID_LEN = 128, NULL-terminated) necessary to log on to the server. See Remarks below.
Password
Specifies the password (of length PE_PASSWORD_LEN = 128, NULL-terminated) necessary to log on to the server. See Remarks below.
|
|
|
|
|
|
|
|
|
Re: How to passing Records type in ORA_FFI.register_parameter ? [message #198600 is a reply to message #198327] |
Tue, 17 October 2006 21:58 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/67467.jpg) |
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
What is happening / not happening? Does it compile and generate? Can you get ANY ora_ffi demos to work?
Are you getting an error message? If yes, post them EXACTLY as they appear on the screen. If necessary cut and paste the screen or screens into a word document, change the 'colour depth' to 8-bit, save and attach the word document to your reply.
David
|
|
|