Hi
Please can someone help me out. I have done quite a bit of searching
and 'trial and error' without much success.
I have simplified the problem for readability, but a solution to this
will allow me to solve my problem.
PROBLEM:
I have a table BATCH_FUNCTION which will contain records with various
existing DB functions, with parameters- (Return Type BOOLEAN).
In an Anonymous Block (lets say for example), if I had a list of the
functions to call in a cursor (select function_name from
batch_function), how would I call these functions with parameters, as
well as be able to test the Return value in my Anonymous block?
I presume that Dynamic SQL is the way to go, but I have not been able
to get it right.
-----------------------------------------------------------------------------------------------------------
EXAMPLE TABLE: BATCH_FUNCTION
-----------------------------------------------------------------------------------------------------------
func_id function_name
----------- ---------------------
111 test_positive(1)
-----------------------------------------------------------------------------------------------------------
EXAMPLE FUNCTION
-----------------------------------------------------------------------------------------------------------
FUNCTION test_positive(i_number IN NUMBER) RETURN BOOLEAN AS
BEGIN
if(i_number >0) THEN
RETURN true;
else
RETURN false;
end if;
END test_positive;
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
