Re: Ansi SQL and stored procedures

I solved the problem! I was using badly the ANSI sql code. That's the version that works:

strncpy( ( char * ) dyn_statement.arr, "call

jaf_test_pkg.GETNOMEFROMCOGNOME1(:cognome,:nome)", SQL_LEN );
dyn_statement.len = ( unsigned short ) strlen( ( char * )
dyn_statement.arr );

EXEC SQL ALLOCATE DESCRIPTOR 'input_descriptor'; EXEC SQL ALLOCATE DESCRIPTOR 'output_descriptor';

EXEC SQL PREPARE prep_statement FROM : dyn_statement;

EXEC SQL SET DESCRIPTOR 'input_descriptor' COUNT=1; // IMPORTANT EXEC SQL SET DESCRIPTOR 'input_descriptor' VALUE 1 TYPE =
:ANSI_varchar_type, LENGTH = :input_len, DATA = :cognome_data;

EXEC SQL SET DESCRIPTOR 'output_descriptor' COUNT=1; // IMPORTANT EXEC SQL SET DESCRIPTOR 'output_descriptor' VALUE 1 TYPE =
:ANSI_varchar_type;

EXEC SQL EXECUTE prep_statement USING DESCRIPTOR 'input_descriptor' INTO DESCRIPTOR 'output_descriptor';

EXEC SQL GET DESCRIPTOR 'output_descriptor' VALUE 1 :result=DATA;   printf("OUTPUT= %s\n\n", result);

---
Thank you! Received on Mon Feb 28 2005 - 17:21:16 CET