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

Home -> Community -> Usenet -> c.d.o.misc -> Execute a stored procedure from OCI

Execute a stored procedure from OCI

From: Rolf C Stadheim <r-stadhe_at_online.no>
Date: Fri, 4 Jan 2002 18:10:00 +0100
Message-ID: <zmlZ7.18743$KQ3.298865@news1.oke.nextra.no> 





How can I execute a stored procedure (a non-select procedure that inserts a
row) from an OCI C-routine?



I have tried



'EXECUTE INSERT_ROOM(45)',


'EXEC SQL INSERT_ROOM(45)',


'BEGIN INSERT_ROOM(45) END;',


'BEGIN INSERT_ROOM(45);'



but all fails with varying error-messages.



I'm using the Oracle 7.3 OCI libraries.



RCS

Received on Fri Jan 04 2002 - 11:10:00 CST












Original text of this message













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