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

2 votes294 views1 answer
Power query concatenate
SQL
29 votes285 views5 answers
Mysql show table structure
SQL
0 vote289 views2 answers
How to display enum value sql server
SQL
0 vote296 views1 answer
Exectuer myssql .sql
SQL
0 vote262 views1 answer
Postgres add prefix to primary key
SQL
1 vote273 views1 answer
Sql try catch
SQL
1 vote303 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote296 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
2 votes325 views2 answers
Oracle create table if not exists
SQL
-1 vote280 views1 answer
Mysql #1064 error
SQL