Home
Discussions
Community Q&A
how to call function in execute sql
sgnarkhede2016
how to call function in execute sql
Find more posts tagged with
AI Studio
Accepted answers
All comments
kayman
Just as you would call it in a 'standard' sql environment. What is your exact problem?
sgnarkhede2016
No values return when passing Execute Sql
CREATE OR REPLACE FUNCTION return_hello(p_name VARCHAR2)
RETURN VARCHAR2 AS
m_return VARCHAR2(1000) := NULL;
BEGIN
m_return := 'HELLO ' || p_name || ' !!';
RETURN m_return;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN NULL;
END;
kayman
You only execute the command with the execute SQL operator, there is no return option in this case.
So it will create your function but in order to use it you'll have to use the Read database operator and then call your created function. This operator has the output option to show the results so you need to combine the execute and read operators.
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)