Proper Use of Pro*C Pointers

From: Robert Carey <robert_w_carey_at_rl.gov>
Date: 1996/03/07
Message-ID: <4hnoo3$7pj_at_columbia>#1/1


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 */
} Received on Thu Mar 07 1996 - 00:00:00 CET

Original text of this message