note afoken <blockquote>Here is the Oracle procedure I'm trying to execute &#91;...&#93; <c>create or replace PROCEDURE abc AS [...]</c></blockquote> <p>This is a PROCEDURE. In your first posting starting this thread, you tried to call it as a FUNCTION.</p> <p>A FUNCTION is something else than a PROCEDURE. Functions must return values, procedures can not return anything. Assigning (or comparing) "the result" of a procedure is impossible, as there is no result, and there can't be one.</p> <p><c>something:=someProcedure</c> is invalid, Oracle told you that, and the Google results for "PLS-00222" would have told you that even more clearly. (And I told you that pretty clear, too.)</p> <p>Alexander</p> <div class="pmsig"><div class="pmsig-747201"> --<br> Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-) </div></div> 813695 813831