Proper Use of Pro*C Pointers
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