Pro*C question

From: Narasimha Kasibhatla <narasimha.kasibhatla_at_daytonoh.ncr.com>
Date: 1996/09/10
Message-ID: <3235C092.7095_at_daytonoh.ncr.com>#1/1


Problem:

     Want to call a stored procedure dynamically from Pro*C.

     Scenario:

     We have a set of stored procedure in the database called say proc1,
     proc2 etc (note names may not be known at compile time).

     Normally within Pro*C you would use

     EXEC SQL BEGIN EXECUTE
        BEGIN proc1 (.. args ..)
        END;
     END EXEC;

     to execute a procedure.

     But we want to call different procedures in Oracle based on what is
     happening in the C program. The names of the procedures would be
     determined at run-time. Therefore, we are looking for some way to
     dynamically prepare a statement that calls a stored procedure and
     execute it.

     Any pointers would be appreciated.

     Please e-mail to hvattyam_at_one.net.

     Thanks

     Hari Vattyam
Received on Tue Sep 10 1996 - 00:00:00 CEST

Original text of this message