I have a strange problem implementing pl/sql procedure. My procedure has four varchar input parameter, and extracts from a table an id value with a query like this:
i have a holiday table which contains the data are HOLIDAYDA DESCRIPTION --------- --------------------
How can you tell if a PL/SQL Package, Procedure, or Function is being used? Is there an Oracle table or view that contains statistics on PL/SQL Package, Procedure, or Fun开发者_开发百科ction usage?You
This is a really simple question, but I can\'t seem to find the syntax for this anywhere. I have something like this:
I\'m trying to call an Oracle stored proc using SQL Developer. The proc outputs results using a sys_refcursor. I right click in the proc window which brings up the Run PL/SQL window. When I choose the
How can i return cursors from oracle user defined functions Like My function should take s开发者_开发知识库ome inputs or no inputs and return me output in a cursor.See this answer to a different que
I have an Oracle DB with a self referencing table of hierarchical medical data called \"services\". Services
I\'ve got the following PL SQL function that returns a ref cursor but the application i am using does not support ref cursors. How can i make this code return something other than ref cursor
This question already has answers here: Can We use threading in PL/SQL? (9 answers) Closed 8 years ago. I need to write something about PL/SQL Parallel execution for a homework and i don\
I have been using Oracle(10g.2) as a PHP programmer for almost 3 years, but when I gave an assignment, I have tried to use the ref cursors and collection types for the first time. And I
加载中,请稍侯......