AnsweredAssumed Answered

Getting output after calling a stored procedure

Question asked by RGoyette on Jul 23, 2010
Latest reply on Nov 2, 2011 by mobilenets


Getting output after calling a stored procedure


We are trying to test calling stored procedures from FM Pro v11 to an oracle database using the Execute SQL script command

Execute SQL [No dialog; DSN:SQL2005; SQL Text: {call database.schema.stored_procedure}]

that someone posted previously.

for us it looks like Execute SQL [No dialog; DNS:TestDB; SQL Text: {call prpsl.hello_world_proc()}]

This Hello World procedure is supposed to return Hello World if it is passed an argument, and an error (ORA -20005 The propsosal id is missing or invalid) if no argument is passed.  The problem is that I can't figure out how to see these responses.

Advice will be greatly appreciated.