<div>
If you are wanting to test, perhaps use an anonymous pl/sql block:
<pre><code class="code-1 nolinks" id="code-20-42686147-1"><span>declare</span>
<span>  opOut sys_refcursor;</span>
<span>  opCount number;</span>
<span>  oResult varchar2(10);</span>
<span>begin</span>
<span>  pkg_product.sp_latest_product('test', opOut, opCount, oResult);</span>
<span>end</span>
</code></pre>
Why did you define o_product as a sys_refcursor? Also, does your package even compile with the &quot;o_product out = 5&quot; assignments?<br />
<br />
Apologies for any syntax errors - I am not at my workstation where I can error check my above code, but it should set you on your way.
</div>


<div>
That looks to me like a SQL Server program that was converted to Oracle. &nbsp;The name of the package, starting with &quot;SP_&quot; is the first clue. &nbsp;That is a apparently a SQL Server standard, or at least very common in SQL Server systems. &nbsp;Also. &quot;out&quot; parameters are common in SQL Server with Microsoft-based applications but not nearly as common with Oracle-based applications. <br />
<br />
Martyn is correct. &nbsp;To call a procedure like this with an Oracle program (like SQL Developer) you need to declare appropriate variables to accept the &quot;out&quot; parameters.
</div>


Software Developer / Linux System Administrator

Martyn Spencer

<div>
I'm getting below error<br />
<br />
<br />
PLS-00103: Encountered the symbol &quot;end-of-file&quot; when expecting one of the following:<br />
<br />
&nbsp; &nbsp;begin function pragma procedure subtype type &lt;an identifier&gt;<br />
&nbsp; &nbsp;&lt;a double-quoted delimited-identifier&gt; current cursor delete<br />
&nbsp; &nbsp;exists prior<br />
06550. 00000 - &nbsp;&quot;line %s, column %s:\n%s&quot;<br />
*Cause: &nbsp; &nbsp;Usually a PL/SQL compilation error.<br />
*Action:
</div>


<div>
Post code. &nbsp;Without the code, there is no way we can determine what that error means. &nbsp;Ideally, post the real error as well, it should actually have the line number, which is very helpful. &nbsp;If you don't have it anymore, you can query USER_ERRORS.
</div>


<div>
There are responses here from three of us, so saying &quot;no response&quot; is not accurate. &nbsp;Maybe you didn't get a response exactly like what you were hoping for, but you didn't reply to johnsone's request that you give us some more information. &nbsp;Without more information from you, there isn't much we can do.
</div>


<div>
I agree with Mark. This question should not be deleted. It contains valid and potentially useful information. You didn't answer my question either.
</div>


<div>
Also agree with Mark. &nbsp;Waiting for answers from author. &nbsp;That isn't a reason to delete.
</div>


<div>
I have marked johnsone's comment as the solution from my point of view because it is the most complete. I do, however feel that my solution was also suitable but naturally cannot state that my comment is also a solution. I will leave it for other experts to decide.
</div>


<div>
<div class="content wysiwyg-content">
How to call or execute below package using oracle sql developer <br />
<br />
<br />
PACKAGE BODY &quot;PKG_PRODUCT&quot;<br />
AS<br />
<br />
PROCEDURE SP_LATEST_PRODUCT(<br />
&nbsp; &nbsp; I_ProductType &nbsp; &nbsp; VARCHAR2,<br />
&nbsp; &nbsp; O_PRODUCT OUT SYS_REFCURSOR,<br />
&nbsp; &nbsp; O_PRODUCTCOUNT OUT NUMBER,<br />
&nbsp; &nbsp; O_RESULT OUT VARCHAR2 )<br />
AS<br />
BEGIN<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;IF UPPER(I_ProductType) &nbsp;= 'CLOTHS' THEN<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;O_PRODUCT OUT = 5;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;ELSE<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;O_PRODUCT OUT = 15;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;END IF;<br />
&nbsp; <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;O_RESULT = 'SUCCESS';<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
END
</div>
</div>


How to call or execute below package using oracle sql developer 


PACKAGE BODY "PKG_PRODUCT"
AS

PROCEDURE SP_LATEST_PRODUCT(
    I_ProductType     VARCHAR2,
    O_PRODUCT OUT SYS_REFCURSOR,
    O_PRODUCTCOUNT OUT NUMBER,
    O_RESULT OUT VARCHAR2 )
AS
BEGIN
	
	  IF UPPER(I_ProductType)  = 'CLOTHS' THEN
			O_PRODUCT OUT = 5;
	  ELSE
			O_PRODUCT OUT = 15;
	  END IF;
  
	O_RESULT = 'SUCCESS';
	
END

how to call oracle package stored procedure with output parameter

PL/SQL

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.