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 vote143 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
8 votes154 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote144 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote120 views1 answer
Name '_mysql' is not defined
SQL
1 vote125 views1 answer
Mysql server does not start mac
SQL
0 vote122 views1 answer
Find largest table in mysql database
SQL
2 votes135 views3 answers
Replace null in sql
SQL
1 vote141 views1 answer
Vagrant mysql downgrade version
SQL
0 vote145 views3 answers
Postgres date difference seconds
SQL
0 vote128 views1 answer
Oracle query to see what scema i am working in
SQL