Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: A pro-C programming question

Re: A pro-C programming question

From: Sigmar Wiesmayr <wis_at_ecolog.at>
Date: Tue, 03 Oct 2000 00:32:11 +0200
Message-ID: <39D90CEB.6848F5A6@ecolog.at>

I can't remember sample10.pc in detail, but:

      sprintf(sql_string,"begin %s
(:inpar1,:inpar2,outpar1,outpar2);end;",

      variablewithprocname);
      EXEC SQL PREPARE xxx FROM :sql_string; 
      EXEC SQL EXECUTE xxx USING :in1,:in2,:ret1,:ret2; 

If you want to use a variable number of parameters please use method 4 as described in
Oracle Documentation for Pro*C.

-- 
Sigmar
Received on Mon Oct 02 2000 - 17:32:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US