Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle performance Tuning 10g reference poster
 
Oracle training in Linux commands
 
Oracle training Excel
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
> execute procedure
mcp_ora
post Apr 12 2012, 09:28 AM
Post #1


Newbie
*

Group: Members
Posts: 2
Joined: 12-April 12
Member No.: 47,073
How do i execute and display results of a procedure declared with ref cursor OUT parameter.

I am using SQL Developer and Oracle 10.2

Thanks
MCP
Go to the top of the page
 
+Quote Post
 
 Start new topic
Replies
burleson
post Apr 18 2012, 09:48 AM
Post #2


Advanced Member
***

Group: Members
Posts: 10,367
Joined: 26-January 04
Member No.: 13
Hi MCP,

Good Niew! I found you a working example:

http://www.dba-oracle.com/t_ora_06504_ref_cursor_out.htm


Just note:

The number of values (3) match, and the OUT and IN are both of type sys_refcursor.

When you get yours working, please post the solution!


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Posts in this topic
- mcp_ora   execute procedure   Apr 12 2012, 09:28 AM
- - burleson   Hi MCP, >> REf cursor as an OUT parameter ...   Apr 12 2012, 10:14 AM
|- - mcp_ora   Thanks for the reply. I have my procedure definit...   Apr 18 2012, 08:40 AM
- - burleson   Hi, A REF CURSOR or cursor variable is just a ref...   Apr 18 2012, 09:12 AM

 

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 20th May 2013 - 11:54 AM
Powered By IP.Board 2.3.6 © 2013  IPS, Inc.