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

1 vote308 views2 answers
Sql where is not number
SQL
0 vote310 views1 answer
Stop psql server windows
SQL
1 vote332 views1 answer
Top 10 rows in mysql
SQL
11 votes336 views2 answers
Insert current date sql
SQL
0 vote319 views1 answer
Original Query
SQL
2 votes363 views2 answers
Postgresql get table names
SQL
3 votes361 views1 answer
Sql set null
SQL
0 vote329 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote355 views1 answer
Nuget sqllite-net-pcl
SQL
0 vote331 views1 answer
Select multiple row from primary key sql
SQL