Re: Pro*C and Roles

In article <4e6m30$8ar_at_news1.radix.net>, jfw_at_radix.net (Jim Ward) wrote:

> Does anyone know if it is possible to set a role using Pro*C?
> The following code below fails...
>
> /*----------------------------------------------------*/
> exec sql begin declare section;
> VARCHAR myrole[20];
> exec sql end declare section;
>
> .. some C code ...
>
> strcpy(myrole.arr, "adpi");
> myrole.len = strlen(myrole.arr);
>
> exec sql set role :myrole;

Just a WAG:

exec sql begin declare section;
varchar mysql[200];
exec sql end declare section;

sprintf(mysql.arr, "set role %s", "adpi"); mysql.len = strlen(mysql.arr);
exec sql execute immediate :mysql;

-- 
Peter Sylvester
MITRE Corp.
Bedford, MA
(peters_at_mitre.org)