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
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 VattyamReceived on Tue Sep 10 1996 - 00:00:00 CEST