Home -> Usenet -> comp.databases.oracle -> Again: Calling a stored procedure from PRO*C

Again: Calling a stored procedure from PRO*C

From: Marcus Winkler <winkler_at_informatik.uni-hannover.de>
Date: Fri, 8 Apr 1994 11:14:01 GMT
Message-ID: <1994Apr8.111401.13356_at_newsserver.rrzn.uni-hannover.de> 






I want to call a stored procedure from a PRO*C program where the procedure's
name is known at runtime. 



I tried it this way:



EXEC SQL BEGIN DECLARE SECTION;



        VARCHAR proc_name;


EXEC SQL END DECLARE SECTION;


strcpy(proc_name.arr,"my_procedure");


proc_name.len=strlen(proc_name.arr);



EXEC SQL EXECUTE


	BEGIN
		winkler.proc_name;
	END;




END-EXEC;


where winkler is my uid.



I can call my_procedure from SQLPLUS with EXECUTE my_procedure, but the
Precompiler tells me:

		ERROR ... PLS-201: identifier 'winkler.proc_name' must be
				   declared.





I am using Oracle 7. Even the sample program 9 in the supplement to the 
Oracle precompiler guide version 1.5 does not work with the call:

	EXEC SQL EXECUTE
		BEGIN
			calldemo.get_employees(....);
		END;
	END-EXEC;





Who can help me ?
Received on Fri Apr 08 1994 - 13:14:01 CEST












Original text of this message