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 -> calling stored procedures using dynamic sql

calling stored procedures using dynamic sql

From: Andrew Holman <akdh_at_ihug.co.nz>
Date: 1997/01/14
Message-ID: <5besme$cks@aknews1.netlink.net.nz>#1/1 







I want to call a stored procedure using proC and dynamic SQL. But I get 
the error "ORA-00900: invalid SQL statement" returned. Does anyone know if 
this is possible or do I have to use embedded SQL.



I have tried calling a stored procedure which takes no parameters using 
method 1 i.e



strcpy (sqlcommand, "calldemo.test_proc");
EXEC SQL EXECUTE IMMEDIATE :sqlcommand;



Also method 2 has been tried.



Thanks


Andrew Holman
Received on Tue Jan 14 1997 - 00:00:00 CST












Original text of this message













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