Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

how to call function in execute sql

sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
in Help
how to call function in execute sql

Answers

  • kaymankayman Member Posts: 662 Unicorn
    Just as you would call it in a 'standard' sql environment. What is your exact problem? 
  • sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
    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;
  • kaymankayman Member Posts: 662 Unicorn
    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.
Sign In or Register to comment.