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

0 vote280 views1 answer
Mariadb errno 121
SQL
0 vote314 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
4 votes272 views1 answer
Force drop all tables postgres
SQL
8 votes297 views2 answers
Oracle undo usage
SQL
3 votes346 views1 answer
Mysql cli connect with password
SQL
0 vote301 views1 answer
Mysql sum per week
SQL
1 vote309 views1 answer
Postgres left join
SQL
3 votes273 views1 answer
Sql timestamp to date
SQL
0 vote265 views1 answer
What is between operator
SQL
1 vote290 views3 answers
Get all tables postgres
SQL