Function plsql

CREATE OR REPLACE FUNCTION my_schema.my_function(param1 IN number) RETURN output1 IS
    cnumber NUMBER;
BEGIN
    cnumber := 2;
    RETURN (cnumber * param1);
EXCEPTION
    WHEN OTHERS THEN
        raise_application_error(-20001, 'An error was encountered - '
            || sqlcode || ' -ERROR- ' || sqlerrm);
END;

Similar codes

17 votes186 views3 answers
Cast in sql server
SQL
0 vote195 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
1 vote185 views1 answer
Sql query row number group by
SQL
0 vote181 views1 answer
How to to get current date in sql
SQL
0 vote186 views1 answer
Can't connect to postgresql mac os
SQL
2 votes243 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote186 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
2 votes202 views1 answer
Metasploit start postgresql
SQL
14 votes259 views1 answer
How to export db from mysql
SQL
1 vote201 views1 answer
How to delay stored procedure execution in sql server
SQL