What are the differences about a function which recieve a refcursor and a function which recieves another function as a parameter?

Question

0.00/5 (No votes)

See more:

I want to know a clear definition about it for general purposes. I want to know which is better to use and in what cases one of them can replace to the other method.

Thanks

SQL

create or replace function abc(edf sys_refcursor)

SQL

create or replace function abc(edf in function)

Sorry about my lack of knowledge, but is this possible?

Posted 21-Sep-14 6:27am

ronalboard

Add a Solution

Comments

Jörgen Andersson 21-Sep-14 17:30pm

A function is not a type.
If you want to use the result of one function as the in parameter of an other function, it is quite possible to do so if the result is of the same type as the in parameter.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Węgierski.A · Accepted Answer · 2014-10-15T22:32:00

There's no function type in Oracle. In such cases I use string parameter with function schema, package, name, parameters, etc. and execute it with EXECUTE IMMEDIATE statement. It's possible to to use parameter masks eg. $parm and next replace it with parameter value:

stmt:=replace(stmt,'$parm','''value''');

I use very complicated code like this, it works fast, and reliable (remember, that, for instance $, . or ' signs are keywords in pattern above).

Maybe, it's possible to use object types with methods in Your case, but I didn't do it.

Using SYS_REFCURSOR works ok in local database, but very slow through database links. Next, it's hard to find cursor result fields.