dynamically called a stored procedure from proC?

[Quoted] Is there a way to dynamically called a stored procedure from proC? I know that you can call a dynamic sql statement. You can get a desciptor and build the statement. However, it seems that you have to create a sql block. Meaning that you have to define a block, something like this example:

  exec sql;
  begin
    stored procedure;
  end;

This works but the stored procedure must be hardcoded between the block. I precompiled the code and it seems that the code that is generated is a string that is pass to another oracle function. I there a way that I can create this string on the fly. I could write something to modify the generated code but this seems to me to be a maintenance nightmare. So, is there a way to do this through proC.

I also tried:
  exe = "execute stored proc";
  EXEC SQL :exe;
The precompiler did not like this statement;

P.S. Also, can I call a function that returns a value. Received on Thu Mar 12 1998 - 00:00:00 CET