Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ref cursor question

ref cursor question

From: <ryan_gaffuri_at_comcast.net>
Date: Wed, 28 Nov 2007 00:02:00 +0000
Message-Id: <112820070002.28114.474CAFF80005885200006DD22207021053079D9A00000E09A1020E979D@comcast.net>


I am returning REF Cursors to an external interface. I want code to test each of these procedures. The problem is that these queries often have 25+ columns in them from several tables.

My test procedure really only needs 1 column to verify the query executes and so I can trace it to check the plan.

so I am looking for something like

fetch myrefcursor.FIRSTCOLUMNONLY in l_myval

Without having to make a new procedure that either has a ref cursor with just 1 column in the select clause . The problem with this option is that every time I change a query, I have to change the code in 2 places. This can easily get out of synch.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 27 2007 - 18:02:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US