Hello all,
Okay, so I may be making this problem more difficult than it appears, but
I'm having a helluva time using ref cursors with dynamic sql in a function.
Anybody done this? Basically I'm trying to construct the select, from and
where clauses via variables; so for instance, I test for acctType (passed in
as a parameter) like so:
if (acctType = 0) then
selectClause := 'select etc.';
elsif (accType = 1) then
selectClause := 'select etc.';
etc. etc.
Then I have one big sqlStmt variable where I concat the select, from, where
clause.
I open the sqlStmt, fetch into a programmer defined record and try and
return this cursor. Problem is sql*plus locks up each time I try to run it.
I never get anything back which leads me to believe that something is
terribly wrong with my approach. I've used an approach outlined in the
Oracle documentation...
Thanks for you help! Hope this makes sense :)
SE Teague
Aresenal Digital Solutions
Data Services
[EMAIL PROTECTED]
919.760.1167
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Susan E Teague
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
