1 Reply Latest reply on Nov 2, 2011 10:32 AM by mobilenets

    Getting output after calling a stored procedure

    RGoyette

      Title

      Getting output after calling a stored procedure

      Post

      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.