AnsweredAssumed Answered

Calling Stored Procedure with GEL - doesn't seem to be successful

Question asked by matpj on Oct 12, 2010
Latest reply on Nov 3, 2011 by Chris_Hackett
Hi all,I have written a stored procedure in our Oracle database which does not take any parameters.The SP reads a table, makes some comparisons and then writes to a custom table.I can run it through my SQL editor software and works fine.  my gel script is structured as follows:   

call P_GLPOST()      if I validate the XML it gets validated  if I run it through GEL via the dos window, it starts but doesn't actually finish or do anything in the database.   Its like it hangs.  When I say it starts, I mean no error is displayed and the cursor blinks as if it does when I am running any other GEL/XOG file.     Does anyone know why this might be happening?     thanks in advance,  Matt