Edit Question - KnowledgeHub

Title Body

I am writing a function and i want to wrap it with table function so i can use with select query. Here is my type declaration and the some lines of my functions CREATE OR REPLACE PACKAGE TYPES AS TYPE CURSORTYPE IS REF CURSOR; TYPE vbugsrec IS RECORD ( bug_id bugs.bug_id%TYPE, facility bugs.facility%TYPE ); TYPE vbugstable IS TABLE OF vbugsrec INDEX BY BINARY_INTEGER; END; / CREATE OR REPLACE PACKAGE BODY CustomQueries AS FUNCTION pendverifylist (myldapid IN userpass.ldapalias%TYPE, maxrows IN PLS_INTEGER:= CustomQueries.maxrecords) RETURN types.vbugstable IS datarows types.vbugstable; var_useralias userpass.ldapalias%TYPE := UPPER (pendverifylist.myldapid) ; CURSOR pendverify_cur ( cursor_var_alias IN userpass.ldapalias%TYPE, cursor_var_mybugstatus IN bugs.bug_status%TYPE, cursor_var_wild IN qa_list.component%TYPE ) IS SELECT buglist.bug_id, buglist.facility FROM bugs buglist, (SELECT qa.product, qa.component FROM qa_list qa, userpass UP WHERE qa.qa_id = UP.userid AND UP.ldapalias = cursor_var_alias) plist WHERE buglist.bug_status = cursor_var_mybugstatus AND buglist.smr_state IN (SELECT fs.finalstate FROM finalstates fs) AND buglist.facility = plist.product AND (buglist.product LIKE plist.component OR plist.component = cursor_var_wild); BEGIN

Tags (comma-separated) Cancel