Re: Proper Use of Pro*C Pointers

robert_w_carey_at_rl.gov (Robert Carey) wrote:
>I have a question about the proper use of Pro*C and using Pointers. >Below is an cheep example, however I don't really know how to=
 reference >the :fun_val variable in my functions select statement.
>
>TNX
>Rob Carey
>robert_w_carey_at_rl.gov
>
>main()
>{
>exec sql begin declare section;
>varchar value[20];
>exec sql end declare section;
>
>exec sql execute
>begin
>
>select 'x' into :value from dual;
>
>end;
>end-exec;
>value.arr[value.len] = '\0';
>/* print referencing value.arr */
>
>Oracle_Fun_NOT( &value );
>
>}
>Oracle_Fun_NOT( fun_val )
>exec sql begin declare section;
>varchar *fun_val;
>exec sql end declare section;
>{
>exec sql execute
>begin
>
>select 'x' into :fun_val from dual;
>
>end;
>end-exec;
>fun_val->arr[fun_val->len] = '\0';
>/* print referencing fun_val->arr */
>}
>

I forgot to add, then you can later on:
Oracle_Fun_NOT (char **value)
{
  EXEC SQL begin declare section;
  char *fun_val;
  EXEC SQL var fun_val is string(20);
  EXEC SQL end declare section;

  fun_val=*value;
  EXEC SQL select 'x' into :fun_val from dual; }

Good luck
Ken Denny Received on Sun Mar 10 1996 - 00:00:00 CET